My theme options, including custom CSS and fonts, appear to have been reset or damaged, most likely due to similar abrupt truncation of database entries. Custom shortcodes, defined by the Shortcoder plugin and stored in the shortcoder_data row in wp_options, are broken because the shortcoder_data entry got abruptly truncated. What's more, database entries end abruptly for instance, some entries in post_content are missing some or most of their original content.
![php mysql create database utf8 encoded php mysql create database utf8 encoded](https://4.bp.blogspot.com/-SmqP3OFOEgQ/T32yVk4yTCI/AAAAAAAAEC8/ojMXcihc05w/s320/564161_3321275764756_1654190085_2639912_1985571085_n.jpg)
Japanese still doesn't display correctly. My site appears the same as it was above, with all themes and settings intact, but now displaying Japanese characters properly.Īctual results for all of the above methods:
![php mysql create database utf8 encoded php mysql create database utf8 encoded](https://wiki.processmaker.com/sites/default/files/3.2DatabaseConnectionsMySQLEncodeSet.png)
![php mysql create database utf8 encoded php mysql create database utf8 encoded](https://www.codexworld.com/wp-content/uploads/2015/05/delete-multiple-records-in-php-by-codexworld.png)
I sought to fix this by changing the database to UTF-8 in a variety of different ways. Looking at my database in phpMyAdmin, I have many tables and columns in my database with their collation set to latin1_swedish_ci. This week, I realized that certain posts on my blog (like these: 1- 2- 3) weren't displaying Japanese characters-the characters either show up as question marks, or as strings of characters like æ-¥æœ¬èªž.Ĭlearly, this is an encoding error. I've been using my WordPress blog since the days when it encoded information in the latin1 charset.