Announcement

Collapse
No announcement yet.

Case Sensitivity in Naming

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Case Sensitivity in Naming

    I save a table with name has both uppercase and lowercase. Navicat still display the table name in lowercase only. Why does Navicat change this? Is there any settings I can config?

  • #2
    Please note that names for databases and tables in MySQL are not case-sentsitive. Display in Navicat doesn't affect the databases and tables in MySQL. For details, you can refer to: http://dev.mysql.com/doc/refman/5.1/en/identifier-case-sensitivity.html

    If you would like to show table with case sentsitive, you can insert lower_case_table_names=0 (the value is according to your needs and the OS type) into the my.ini file in MySQL folder. Please stop and restart the server before and after editing.

    Comment

    Working...
    X