Hi ! I have wp db containing sometime chinese chars in european text... until WP 2.2 and WPDBP 2.1.2 no pb to restore from a remote db to a local db - I recover chinese chars...
Since WP 2.3 and since WPDBP 2.1.3, after restore to my local db, I recover the accentuated chars but not the chinese chars transformed in ????...
Something has changed but I am not able to see what ?
More informations after more investigations : WPDBU seem to be not the origin of the pb because when used as
WPDBU 214 + WP 2.2.3 = no pb after restoration to recover both accentuated chars and chinese chars in post.
The only problematic couple is WP2.3 and WPDBU 214 probably because something change how WP2.3 store contents in post.
In the config.php the new line seem to have influence : - define('DB_CHARSET', 'utf8'); - When present, the pb is similar : writing a post with both accentuated chars and chinese chars. and on screen you see the chinese char transformed in ????....
The line - define(’DB_CHARSET’, ‘utf8′); - is very important - the online newly WP23 was created without this line (a faulty copy of a previous version of wp-config.php) but remain in the local WP23 wp-config.php.... it is why the restored DB show this pb of chars (a latin table was treated as a UTF8 table...).
Conclusion : verify the wp-config.php of the remote (online) and the local WP23.
Hi ! I have wp db containing sometime chinese chars in european text... until WP 2.2 and WPDBP 2.1.2 no pb to restore from a remote db to a local db - I recover chinese chars...
Since WP 2.3 and since WPDBP 2.1.3, after restore to my local db, I recover the accentuated chars but not the chinese chars transformed in ????...
Something has changed but I am not able to see what ?
Best Regards
MS
More informations after more investigations : WPDBU seem to be not the origin of the pb because when used as
WPDBU 214 + WP 2.2.3 = no pb after restoration to recover both accentuated chars and chinese chars in post.
The only problematic couple is WP2.3 and WPDBU 214 probably because something change how WP2.3 store contents in post.
In the config.php the new line seem to have influence : - define('DB_CHARSET', 'utf8'); - When present, the pb is similar : writing a post with both accentuated chars and chinese chars. and on screen you see the chinese char transformed in ????....
EPILOGUE : after investigations....
The line - define(’DB_CHARSET’, ‘utf8′); - is very important - the online newly WP23 was created without this line (a faulty copy of a previous version of wp-config.php) but remain in the local WP23 wp-config.php.... it is why the restored DB show this pb of chars (a latin table was treated as a UTF8 table...).
Conclusion : verify the wp-config.php of the remote (online) and the local WP23.
NOTE: upgrading from previous version (WP2.1.x) and converting from Latin to UTF8 seem to be a serious goal as described in http://www.mydigitallife.info/2007/06/23/how-to-convert-character-set-and-collation-of-wordpress-database/
RSS feed for this topic
Reply
You must log in to post.