Scott- Are you using the ODBC bridge or JDBC? I do suspect this is a JDBC issue. I seem to remember that the MySQL JDBC drivers shipped with CFMX 6 were for an older version of MySQL then those that shipped with CFMX8. I suspect the way they construct the JDBC URL string may be slightly different as well, which may be turning on some options relating to the ASCII codes you are seeing.
I would visit the MySQL developer support site (dev.mysql.com), download the latest drivers for the version of MySQL you are using, and then install them on both the CF6 and CF8 boxes to make sure you have the same thing running in both places. There are several blog posts out there about how to do this if you need better directions than mine... I am also assuming it's the same version of MySQL for both CF boxes? -Cameron On Mon, Sep 21, 2009 at 12:21 PM, Scott Weikert <[email protected]> wrote: > > Hey gang - > > In the middle of a project and have run across an oddity, and I have yet > to find any answers - I'm under the gun here. > > Working on migrating our main database from MS SQL Server to MySQL. So > far so good. > > Two different versions of CF running on different boxes - CF8 (works > great) and CF6 (problem). > > On the CF6 box, queries to tables that work fine in CF8 have an issue - > bit fields don't return 0 or 1 - instead they're returning the ASCII > codes for 0 and 1. > > Is this an ODBC driver issue or what? I can code around it for the > meantime but I'd like to get it back to returning the query results I'm > used to. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326461 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
