[wp-trac] [WordPress Trac] #44440: Case sensitive/insensitive bug

[WordPress Trac]

#44440: Case sensitive/insensitive bug
--------------------------+----------------------
 Reporter:  dingdang      |       Owner:  (none)
     Type:  defect (bug)  |      Status:  closed
 Priority:  normal        |   Milestone:
Component:  Database      |     Version:  4.9.6
 Severity:  normal        |  Resolution:  invalid
 Keywords:  needs-patch   |     Focuses:
--------------------------+----------------------

Comment (by theking2):

 Difference in case sensitivity is expected behaviour when migrating
 between Windows and Linux even in database table names, this is due to
 Windows being case insensitive (NTFS ''is'' case sensitive), while all
 Linux filesystems are case sensitive.

 MySQL and MariaDB have to take this in account as MYISAM stores tables in
 files with the same name. In Windows this potentially creates clashing
 filenames. Thereupon during installation of MySQL it sets system variable
 **lower_case_table_names** to 1 on Windows (0 on Linux and 2 on macOS)

 I recommend only using lower case characters as table prefix if you intend
 to migrate them between different operating systems.

-- 
Ticket URL: <https://core.trac.wordpress.org/ticket/44440#comment:9>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform