) WordPress
WordPress 2.2, WordPress WordPress DB_CHARSET DB_COLLATE wp-config.php . , WordPress ( , ) (i.e. ) , , ) ) .
, WordPress upgraded ) WordPress UTF-8 , , , ( , MySQL multilingual blog WordPress, blog , - , WordPress , , - lots ) ????? ( ), WordPress . ( , )
WordPress , UTF-8 . , = CAN MySQL phpMyAdmin hoping . WordPress , sets using MySQL . sets, ( ) , UTF-8, , WordPress
WordPress MySQL , UTF-8. , , . , , WP , ) , . , - , ? , ) , .
andersapt convert_to_utf8_sql_generator.txt ) SQL WordPress UTF8 . , , , , , ’ ) SQL “PHP get_results() non- convert.php 37″. , , , utf8_general_ci .
UTF-8 , ’ . .
WordPress UTF8 ( )
- WordPress blog offline - ) - .
- , . ’ using cPanel , ’ , ) SQL ,
- convert_to_utf8_sql_generator.txt PHP .
- WordPress blog using. , :
Tables_in_DATABASENAME
DATABASENAME WordPress . , ,
Tables_in_wp_mydigitallife
- Upload convert_to_utf8_sql_generator.php ( convert.php) WordPress , wp-config.php ,.
- , , - , . , convert_to_utf8_sql_generator.php ( - ) ) blog URL (i.e http:/www.mywebsite.com/convert_to_utf8_sql_generator.php) . ) SQL .
- post_content , wp_posts - FULLTEXT . ) , ) . , , . , .
1170 (42000): / ‘post_content’
1283 (HY000): ‘post_content’ = can ) FULLTEXT
- Telnet SSH. ) using Unix phpMyAdmin - , . , feedback .
- MySQL .
- MySQL :
DATABASENAME;
, DATABASENAME WordPress .
- ) SQL , MySQL . SQL MySQL . ,, .
- , . , , :
wp_categories.category_nicename
wp_comments.comment_approved
wp_links.link_visible
wp_options.option_name
wp_postmeta.meta_key
wp_posts.post_status
wp_posts.post_name
wp_posts.post_type
wp_usermeta.meta_key
wp_users.user_login, non-ASCII . , category_nicename ( ) post_name ( ) URL ( URL non-alphanumeric (%) hex (+) ). ) byte UTF-8 ASCII, ) , UTF8 .
- wp-config.php DB_CHARSET DB_COLLATE . , ) MySQL :
defineDB_CHARSET(’’, ‘utf8′);
defineDB_COLLATE(’’, ”);WordPress , DB_COLLATE ( ) MySQL .
- / FULLTEXT , -.
- blog .
- blog .
- PHP .
- WordPress , Upgrading 2.2
- ( ) MySQL Databases
- -00016
- WordPress 2.2
- EXP-00091
- WordPress 2.6
- MySQL /
- , WordPress
- WordPress 2.3 1 (RC1)
- WordPress Blog
Entries (RSS)
23rd, 2007 0427:
…
( ) m , utf8 -8
..
table_name
mysql / , .
, , varchar varbinary, (tynitext, , mediumtext, longtext) (tinyblob, , mediumblob, longblob) enum .
) ) .
BTW ) using .
mistyping .
11th, 2007 1600:
[...] MySQL 本身的問題，便一知半解地去亂 set，結果一樣。。。 (500:) 直至我讀完這篇文章，發現是 WP 由 2.1 升至 2.2.1 之後，閱讀 db 的 真的變了，讀不了 SQL db [...]
21st, 2007 1533:
[...] , – ,- -setcharset_name= UTF8. [...]
4th, 2007 1857:
[...] Schnauze. Mit etwas mehr Hartnäckigkeit bei der konnte ich dann doch noch eine Konvertierungsanleitung , auf mystische und Weise sowohl auf das fehlerhafte hinweist, als auch [...]
16th, 2007 0204:
dont’ ?
.
16th, 2007 0315:
[...] UTF8 blog ’ . didnt’ , ( ), [...]
16th, 2007 0359:
, , ’ - bugs .
29th, 2007 0323:
[...] codificación , acentos, ñ símbolos que funcionara . recomiendo artículo que los pasos tu bbdd codificación [...]
17th, 2007 0755:
[...] , siempre algo que va desconfigurado: los los comentarios. probado
19th, 2007 0335:
[...] ficheiro wp-config.php deixar os das DB_CHARSET DB_COLLATE m . solução é , UTF-8, que mim já soa [...]
14th, 2007 0305:
, using MyPHPAdmin.
.
27th, 2008 0120:
Im’ using PHPmyAdmin utf-8, butPHPmA… ( ur ).
PHPmA ?
Thx !
2nd, 2008 0152:
[...] ) wordpress ? [...]
19th, 2008 0332:
. ) , , , “upgraded” , . phpmyadmin . .
31st, 2008 1309:
[...] ) WordPress WordPress UTF8 ( ) — » [...]
19th, 2008 1219:
[...] troubleshooting ) 2 wp-config.php . , didnt’ . ) SQL . [...]
24th, 2008 1853:
Ive’ uploaded , . utf8 . utf8 wp-config.php DB_CHARSET DB_COLLATE .