Hi Henning, maybe there is no need for TEXT, but for sure you need some escaping for BLOB type - I remember this issue some time ago in the the postgres module.
Regards, Bogdan Henning Westerholt wrote: > On Sunday 20 April 2008, Bogdan-Andrei Iancu wrote: > >> I think option 2 will be better, mainly because we have 2 different data >> types - BLOB cannot be 100% mapped over string as BLOB was specifically >> design for: >> 1) large amount of data (not suitable for STRING) >> 2) data containing any kind of chars/bytes (not suitable for >> STRING, like \0) >> >> For BLOB processing, most of the database libs provide specific function >> to escape, un-escape data when comes to BLOB, and such code already >> exists in openser. >> >> Also, this will maintain some consistency at the data level and avoid >> mixing them (and create confusion). >> > > Hi Bogdan, > > according to http://dev.mysql.com/doc/refman/5.0/en/blob.html TEXT colums are > treated as non-binary strings, so its not allowed to store binary data in > them. So the usage of the specific escaping functions is not really > necessary. But the length argument is valid anyway. > > So i'll convert the db_unixodbc and db_postgres drivers to use this logic. > > Cheers, > > Henning > > _______________________________________________ Devel mailing list Devel@lists.openser.org http://lists.openser.org/cgi-bin/mailman/listinfo/devel