MySql in solaris is it case sensetive? 1

[avihaimar]

Hey,

I run sql command in my java program.
The table name is in capital letter.
in my sql command i wrote the table name in small letter.

The sql command work in mysql on windows,but didnt work on solaris.

I understand that there is a differnt behaviour between mysql on solais and window. is it right?

Does any one know where can i chnage the database settings to be insensitive

Thank you

 

[TonyGroves]

Each MyISAM table is represented by a set of files with the same basename as the table, so in a case-sensitive filesystem such as those used by Unix-like systems, table names are also case-sensitive by default.

However this can be overridden by adding the "lower_case_table_names=1" option in your my.cnf file, which converts table names to lowercase before processing queries.

In your case, the table is already in uppercase, so you would also need to either (1) stop the server and rename the corresponding filenames to lowercase, or (2) create a new table (with a lowercase name) as a copy of the old one, and delete the old one.

 

[avihaimar]

I saw in some place that they want to change the default behavior to be by default case insensitive on all platform.

Is it correct?



Thank you

 

[TonyGroves]

Quite possibly. You could check the MySQL manual.