[GitHub] [incubator-shardingsphere] taojintianxia commented on issue #2948: My database table names are all uppercase , how to config ?

[GitBox <gi...@apache.org>]

taojintianxia commented on issue #2948: My database table names are all uppercase , how to config ?
URL: https://github.com/apache/incubator-shardingsphere/issues/2948#issuecomment-528685527
 
 
   > In MySQL, databases correspond to directories within the data directory. Each table within a database corresponds to at least one file within the database directory (and possibly more, depending on the storage engine). Triggers also correspond to files. Consequently, the case sensitivity of the underlying operating system plays a part in the case sensitivity of database, table, and trigger names. This means such names are not case-sensitive in Windows, but are case-sensitive in most varieties of Unix. One notable exception is macOS, which is Unix-based but uses a default file system type (HFS+) that is not case-sensitive. However, macOS also supports UFS volumes, which are case-sensitive just as on any Unix.
   
   https://dev.mysql.com/doc/refman/5.7/en/identifier-case-sensitivity.html
   
   maybe just for ignoring the negative effects of case sensitive

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services