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. On 8/13/06, Jim McAtee <[EMAIL PROTECTED]> wrote: > > 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 twos lets me (more or less) get the original ASCII string. The > problem I'm running into is that I can only retrieve strings of a maximum > size of 18 ASCII characters (36 hex characters). Any ideas of what's > going on? I looked for something within the MySQL ODBC driver setup for > the DSN, but didn't see anything promising. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:249685 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4