[wp-trac] [WordPress Trac] #32279: Creating new posts/terms with non-latin characters is broken for tables with cp1251 collation in 4.1.5

[WordPress Trac]

#32279: Creating new posts/terms with non-latin characters is broken for tables
with cp1251 collation in 4.1.5
--------------------------+--------------------
 Reporter:  vloo          |       Owner:
     Type:  defect (bug)  |      Status:  new
 Priority:  high          |   Milestone:  4.2.3
Component:  Database      |     Version:  4.1.5
 Severity:  critical      |  Resolution:
 Keywords:                |     Focuses:
--------------------------+--------------------

Comment (by SergeyBiryukov):

 Confirmed. All branches from 3.7.8 to 4.2.2 appear to be affected.

 Steps to reproduce:
 1. Get a [https://bg.wordpress.org/ Bulgarian] or
 [https://ru.wordpress.org/ Russian] package.
 2. Before installing, set `DB_CHARSET` to `cp1251` in `wp-config.php`.
 3. Proceed with installing.

 When you try to view the site after installing:
 * The default content is missing.
 * Most of the options in `wp_options` are missing.

 When you try to log in:
 * It tells you that a DB upgrade is needed.
 * During the upgrade, there's a bunch of errors:
 {{{
 WordPress database error: [Table 'wordpress.wp422_categories' doesn't
 exist]
 SELECT cat_ID, cat_name, category_nicename FROM wp422_categories

 WordPress database error: [Table 'wordpress.wp422_post2cat' doesn't exist]
 SELECT DISTINCT post_id FROM wp422_post2cat

 WordPress database error: [Unknown column 'post_category' in 'field list']
 SELECT ID, post_category FROM wp422_posts WHERE post_category != '0'

 WordPress database error: [Table 'wordpress.wp422_categories' doesn't
 exist]
 ALTER TABLE `wp422_categories` ADD INDEX ( `category_nicename` )

 WordPress database error: [Key column 'link_category' doesn't exist in
 table]
 ALTER TABLE `wp422_links` ADD INDEX ( `link_category` )

 WordPress database error: [Unknown column 'user_nickname' in 'field list']
 SELECT ID, user_nickname, user_nicename FROM wp422_users

 WordPress database error: [Table 'wordpress.wp422_categories' doesn't
 exist]
 SELECT * FROM wp422_categories ORDER BY cat_ID

 WordPress database error: [Table 'wordpress.wp422_post2cat' doesn't exist]
 SELECT post_id, category_id FROM wp422_post2cat GROUP BY post_id,
 category_id

 WordPress database error: [Table 'wordpress.wp422_linkcategories' doesn't
 exist]
 SELECT cat_id, cat_name FROM wp422_linkcategories

 WordPress database error: [Unknown column 'link_category' in 'field list']
 SELECT link_id, link_category FROM wp422_links
 }}}

 Previous release in each branch (3.7.7 to 4.2.1) works correctly.

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