Re: [SQLObject] InformixDB

[Mark R. <mar...@gm...>]

On 12/15/05, Mark Rees <mar...@gm...> wrote:

> Happy to use BLOBCol as a workround.

Argh, the informix DBI does do automatic translation from a string to
a TEXT BLOB, you still have to create a buffer. And since standard
SQLObject functionality is to create pure string INSERT's and UPDATES
I am back to my original problem. So have three options,

- use the a connection specific insertSQL and _SO_update  methods so
BLOBCol will work with placeholders. Have the code for this working
great with the TurboGears wiki turtorial using informix as it's data
store.

- Or see if informixdb can be modified to do auto casting from string
to BLOB. Yuk C code.

- Or provide an informix connection that is very limited in it's
support for large strings.

Mark