Have u tried any other drivers ? -----Original Message----- From: Jim McAtee [mailto:[EMAIL PROTECTED] Sent: 13 August 2006 20:17 To: CF-Talk Subject: OT: MyODBC and blobs with text
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:249688 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4