MySQL Forums
Forum List  »  Microsoft SQL Server

Table names case sensivity
Posted by: Svyatoslav Lavryk
Date: June 02, 2005 03:43AM

I have a problem while migrating the MS SQL db to MySQL on FreeBSD. In MS SQL db I have table names in both cases (for, example 'Resource'). When import db into MySQL, tables are created in lower case (I get the corresponding MySQL table 'resource').
When I try to execute any query containing 'Resource' table name I get 'Table not found' error. That's because of case sensivity on FreeBSD.

I have no opportunity to change sql queries to use lower case table names.

Nor I have the opportunity to restart MySQL server with --lower_case_table_names=1 key, which would solve the problem.

I investigated If I can change the corresponding session variable, but again no luck.

If anyone has any ideas how to solve such problem with respect to the stated limitations, any comments would be appreciated.

Thanks in advance.

Options: ReplyQuote

Written By
Table names case sensivity
June 02, 2005 03:43AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.