> Queries (and dumps) all run fine with either SQL statements alone or > with cfc and cfm scripts in CF8. With CF9 however, the encrypted > fields are returned as binary via cfdump even though the SQL > statements themselves all run fine using Navicat for MySQL. I can > overcome this by recoding he relevant cfm using > CharsetEncode(datafield, "utf-8") but this results in an error when > used with CF8. Any thoughts or suggestions would be greatly > appreciated.
It sounds a lot like this old MySQL bug. Though the comments say it was fixed eons ago. If not, try casting it to a string in the sql http://bugs.mysql.com/bug.php?id=12872 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3350 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/sql/unsubscribe.cfm
