> Anyone using CF and mySQL and accessing BLOB data? I converted an Access2K
> db to Mysql and all memo fields were converted to BLOB datatypes. Now when
I
> pull the information and display it I get ASCII garbage and not the text.
> Someone in mySQL support told me to change it to a longvarchar datatype
but
> that would require reconverting the database a second time which I would
> like to avoid.
>
> Anyone run into this problem? Is there any way around it ?
Change your BLOB types to TEXT, TINYBLOB to TINYTEXT and MEDIUMBLOB to
MEDIUMTEXT
with ALTER TABLE sentences. That does the trick.
Erki
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.