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:249683 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4