> > But why not do the conversion on the Access side before migrating to > MySQL? In Access you can simply rename the tables to the case you use > in your queries before you convert them. >
IIRC there is a setting in my.cnf that will automatically lower case table names. To turn it off you have to set it to 0 --lower-case-table-names=0 I think that the default setting is to lower case table names... It was a while back so forgive me if I am hazy on the details. More details can be found here: http://www.heidisql.com/forum.php?t=667#p3653 http://dev.mysql.com/doc/refman/5.5/en/identifier-case-sensitivity.html The way I got a round it was to either do a search and replace and lower case the table names in the code or to change the table names in the database using a MySQL GUI. Again, I forget the details, I was in a bit of a rage at the time. ;) HTH G! On Fri, Feb 26, 2010 at 10:05 AM, Jochem van Dieten <joch...@gmail.com>wrote: > > On Fri, Feb 26, 2010 at 2:01 PM, Andrew Scott wrote: > > Have you tried talking to your hosting provider, and switch case > sensitivity > > off for your database? > > That is not a per-database setting. Once you have it set to some > setting and have clients on it, a hosting provider is committed and > can not change it anymore. > > But why not do the conversion on the Access side before migrating to > MySQL? In Access you can simply rename the tables to the case you use > in your queries before you convert them. > > Jochem > > -- > Jochem van Dieten > http://jochem.vandieten.net/ > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:331173 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4