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

[WordPress Trac]

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

Comment (by pbiron):

 Replying to [comment:3 dingdang]:
 > In Windows also prefix setting in wp-config.php is lowered case, while
 in Linux it s mixed ("pReFiX_").

 Are you saying that `wp-config.php` on windows contains:

 {{{#!php
 <?php
 $table_prefix = 'prefix_';
 }}}

 and on linix it contains:
 {{{#!php
 <?php
 $table_prefix = 'pReFiX_';
 }}}

 If so, then I'm lost.  If you've got `$table_prefix = 'prefix_'` on
 windows and you populated the database on windows, how did you get the row
 in `$wpdb->options` to have `option_name === 'pReFiX_user_roles'`?

 Also, if that is what you're doing, **why** are you doing that?  It's kind
 of like having `wp-config.php` on windows contain

 {{{#!php
 <?php
 define( 'DB_CHARSET', 'utf8' );
 }}}

 and on linix having it contain:

 {{{#!php
 <?php
 define( 'DB_CHARSET', 'ascii' );
 }}}

 and then wondering why when you "migrate from windows to linux" you get
 data corruption.

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