[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 ReneHermi):

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

 This would require that a user is aware of this issue and has the
 technical knowledge to forecast it. That's very unlikely.

 We could show a warning to always use lower case table names and prefixes
 even on windows environment. So if user ever wants to migrate to another
 OS due to changed requirements it will reduce the risk of running into an
 issue.

 So if there is no consence to fix this issue programmatically, we at least
 should show a warning in the installer dialogue and recommend the use of
 lower case prefix names. This can be a tooltip or one liner and will
 prevent user from experiencing migration issues in the future.

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