ID #1091

Are the SQLyog SYNC tools case sensitive?

 

No!


As of now (SQLyog 5.12) both the SCHEMA SYNC tool and the DATA SYNC tool operate in a case-insensitive way, as far as table names (but not string data, of course!) is concerned.

There are plans for the near future to query the system variable 'lower_case_table_names' and perform the sync case-sensitive or case-insensitive according to the values for 'lower_case_table_names' retrieved.


Note that if not explicitly set the 'lower_case_table_names' system variable takes it value from the system variable 'lower_case_file_system'. That is why Linux most often is case sensitive with table names and Windows most often is case-insensitive, for instance.

Also note that columns names always are case-insensitive with MySQL.

 

Categories for this entry

Tags: -

Related entries:

Last update: 2009-02-16 05:33
Author: Peter Laursen
Revision: 1.3

{writeDiggMsgTag} {writeFacebookMsgTag} {writePrintMsgTag} {writeSend2FriendMsgTag} {writePDFTag}
{translationForm}
Rate this FAQ

Average rating: 0 (0 Votes)

completely useless 1 2 3 4 5 most valuable

You can comment this FAQ