Table Names Lose Uppercase When Copied From Linux Mysql To Wamp Mysql

[sathish]

Hello,

Its the MySQL server that modifies the letter case. The behavior can be controlled by setting lower_case_table_names.

Please execute SHOW VARIABLES LIKE 'lower_case_table_names'; and compare the result with the documentation given here.

http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html

Refer http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysvar_lower_case_table_names to see how you can set this variable to match your requirements.

However it is advised to use this variable set to 1 in case insensitive file systems and use only lowercase to name your database and tables for maximum portability. In short, MySQL recommends the use of delimiter_separated naming convention over CamelCase naming convention.

Regards,

Sathish

[mbabineau]

Ok, that makes sense. I'll just convert everything to lower case with “_” separators…..that will solve my problem!

Thanks,

Matt

'sathish' wrote:

Hello,

Its the MySQL server that modifies the letter case. The behavior can be controlled by setting lower_case_table_names.

Please execute SHOW VARIABLES LIKE 'lower_case_table_names'; and compare the result with the documentation given here.

http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html

Refer http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysvar_lower_case_table_names to see how you can set this variable to match your requirements.

However it is advised to use this variable set to 1 in case insensitive file systems and use only lowercase to name your database and tables for maximum portability. In short, MySQL recommends the use of delimiter_separated naming convention over CamelCase naming convention.

Regards,

Sathish

[Author]

Posts