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

[WordPress Trac]

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

 * status:  closed => reopened
 * resolution:  invalid =>


Comment:

 Even MySQL recommends lowercases due to the mentioned complications:

 " To avoid problems caused by such differences, it is best to adopt a
 consistent convention, such as always creating and referring to databases
 and tables using lowercase names. This convention is recommended for
 maximum portability and ease of use."

 Source: https://dev.mysql.com/doc/refman/5.7/en/identifier-case-
 sensitivity.html

 A quick fix would be to convert the selected table prefix to lowercase
 when WordPress is installed. This would be fully compatible for existing
 sites and would fix the issue for all future installations.

 At WP Staging we experienced this serious issue several times when people
 select a prefix with capitalization and they move their site from Windows
 to Linux.

 With uppercase table prefixes, it's very difficult to move a WP site from
 one system to another and there is no way to do this automatically.

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