OT: MyODBC and blobs with text

2006-08-13 Thread Jim McAtee
I have a database (that I didn't develop) with tables that contain text stored in columns of type blob. I believe the reasoning behind this was to to be able to store various language character sets. When I query these from CF using MyODBC I see hexadecimal strings, but grouping these into tw

Re: OT: MyODBC and blobs with text

2006-08-13 Thread Michael Traher
I have read and written long data types in mysql using the jdbc driver and that has worked fine. never tried the ODBC driver. I did get an error relating to a buffer setting when I tried larger data sizes (much larger I mean 50MB+) but this error was easy to find in the mysql reference manual.