MySQL Forums
Forum List  »  Partitioning

Advanced Search
New Topic

Re: Can partition a table with the name "users" but not with "Users"
Posted by: Mattias Jonsson
Date: February 03, 2009 02:32AM

Also be aware that OS X default filesystem have case preserving/case insensitive file system.

So usually lower_case_table_names = 2 on OS X, 1 on windows and 0 on *nix.

Which means that you cannot use the same name with different case on windows and OS X, but it is possible on *nix.

See
http://dev.mysql.com/doc/refman/5.1/en/identifier-case-sensitivity.html
http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#sysvar_lower_case_table_names

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Can partition a table with the name "users" but not with "Users"
3910
Sepp Maier
January 29, 2009 12:08PM
Re: Can partition a table with the name "users" but not with "Users"
2430
Sepp Maier
January 30, 2009 05:29AM
Re: Can partition a table with the name "users" but not with "Users"
2466
Mattias Jonsson
February 03, 2009 02:32AM


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.