[wp-trac] [WordPress Trac] #32090: Bug: Can not update tables in non-wordpress-installation databases when the query contains non ASCII characters

[WordPress Trac]

#32090: Bug: Can not update tables in non-wordpress-installation databases when the
query contains non ASCII characters
--------------------------+--------------------
 Reporter:  willstedt     |       Owner:
     Type:  defect (bug)  |      Status:  new
 Priority:  normal        |   Milestone:  4.2.1
Component:  Database      |     Version:  4.1.2
 Severity:  normal        |  Resolution:
 Keywords:                |     Focuses:
--------------------------+--------------------

Comment (by pento):

 Another note for when we fix this - I'm not sure that `\w` is the correct
 thing to use in the regex, to match table names. Per the
 [https://dev.mysql.com/doc/refman/5.5/en/identifiers.html MySQL docs],
 there's a large range of characters that are valid in object names. The
 [https://php.net/manual/en/regexp.reference.escape.php PHP docs] imply
 that `\w` only matches a locale-specific set of characters.

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