Problem is that in my code over the years the table name can be as 'Company' or 'company' so just changing the table names in mysql to lowercase is not enough but yes a necessary step (can do it from the GUI: PHPadmin) Then as you wrote changing all occurrences of the table names (1500 cfquery tags) to lowercase. I choose lowercase but it could be also uppercase as long as everything on the code and db is coherent. Anyway that is the only solution that I find at this time.
Changing the db to0 be case non sensitive because as someone already mentioned it is a shared environment so other clients would get in troubles. Thanks guys for the great feedbacks! >> >> 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: > >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:331177 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
