) 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 ( )

  1. WordPress blog offline - ) - .
  2. , . ’ using cPanel , , ) SQL ,
  3. convert_to_utf8_sql_generator.txt PHP .
  4. WordPress blog using. , :

    Tables_in_DATABASENAME

    DATABASENAME WordPress . , ,

    Tables_in_wp_mydigitallife

  5. Upload convert_to_utf8_sql_generator.php ( convert.php) WordPress , wp-config.php ,.
  6. , , - , . , convert_to_utf8_sql_generator.php ( - ) ) blog URL (i.e http:/www.mywebsite.com/convert_to_utf8_sql_generator.php) . ) SQL .
  7. post_content , wp_posts - FULLTEXT . ) , ) . , , . , .

    1170 (42000): / ‘post_content’

    1283 (HY000): ‘post_content’ = can ) FULLTEXT

  8. Telnet SSH. ) using Unix phpMyAdmin - , . , feedback .
  9. MySQL .
  10. MySQL :

    DATABASENAME;

    , DATABASENAME WordPress .

  11. ) SQL , MySQL . SQL MySQL . ,, .
  12. , . , , :

    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 .

  13. wp-config.php DB_CHARSET DB_COLLATE . , ) MySQL :

    defineDB_CHARSET(’’, ‘utf8′);
    defineDB_COLLATE(’’, ”);

    WordPress , DB_COLLATE ( ) MySQL .

  14. / FULLTEXT , -.
  15. blog .
  16. blog .
  17. PHP .

: " " . . , .

.



17 ) WordPress

  1. g30rg3_x
    23rd, 2007 0427:
    1


    ( ) m , utf8 -8

    ..
    table_name
    mysql / , .
    , , varchar varbinary, (tynitext, , mediumtext, longtext) (tinyblob, , mediumblob, longblob) enum .

    ) ) .

    BTW ) using .

    mistyping .

  2. fotizo φωτίζω » Blog » Wordpress 2.1 > 2.2.1
    11th, 2007 1600:
    2

    [...] MySQL 本身的問題,便一知半解地去亂 set,結果一樣。。。 (500:) 直至我讀完這篇文章,發現是 WP 由 2.1 升至 2.2.1 之後,閱讀 db 的 真的變了,讀不了 SQL db [...]

  3. ( ) MySQL Databases »
    21st, 2007 1533:
    3

    [...] , ,- -setcharset_name= UTF8. [...]

  4. Wordpress 2.2 UTF Konvertierung | BlogCHA[] v2
    4th, 2007 1857:
    4

    [...] 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 [...]


  5. 16th, 2007 0204:
    5

    dont’ ?

    .

  6. curo.dk » Blog » Wordpress ,
    16th, 2007 0315:
    6

    [...] UTF8 blog . didnt’ , ( ), [...]

  7. admin
    16th, 2007 0359:
    7

    , , - bugs .


  8. 29th, 2007 0323:
    8

    [...] codificación , acentos, ñ símbolos que funcionara . recomiendo artículo que los pasos tu bbdd codificación [...]

  9. Octaedro » Una soluci
    17th, 2007 0755:
    9

    [...] , siempre algo que va desconfigurado: los los comentarios. probado

  10. ! | isa * geek
    19th, 2007 0335:
    10

    [...] ficheiro wp-config.php deixar os das DB_CHARSET DB_COLLATE m . solução é , UTF-8, que mim já soa [...]

  11. Nascimento
    14th, 2007 0305:
    11

    , using MyPHPAdmin.

    .


  12. 27th, 2008 0120:
    12

    Im’ using PHPmyAdmin utf-8, butPHPmA… ( ur ).

    PHPmA ?

    Thx !

  13. : 2008030101
    2nd, 2008 0152:
    13

    [...] ) wordpress ?  [...]


  14. 19th, 2008 0332:
    14

    . ) , , , “upgraded” , . phpmyadmin . .

  15. 2008-03-30 [del.icio.us] » BD-
    31st, 2008 1309:
    15

    [...] ) WordPress WordPress UTF8 ( ) — » [...]

  16. … @ … » UTF-8
    19th, 2008 1219:
    16

    [...] troubleshooting ) 2 wp-config.php . , didnt’ . ) SQL . [...]

  17. -
    24th, 2008 1853:
    17

    Ive’ uploaded , . utf8 . utf8 wp-config.php DB_CHARSET DB_COLLATE .

: < href="" =""> <abbr =""> < =""> < > <blockquote =""> < > < > <del datetime=""> < m> < > <q =""> < > < >



Custom Search

phpmyadmin - MySQL - mysql - - mysql - mysql , - - , - php - mysql - phpmyadmin - phpmyadmin - wordpress - phpmyadmin - wordpress , - wordpress latin1_swedish_ci - mysql utf8 - - phpmyadmin - - mysql - - mysql - mysql - php - mysql - - phpmyadmin - phpmyadmin - latin1_swedish_ci utf8 - mysql - mysql - - mysql , - php , - latin1_swedish_ci wordpress - php - - sql , - mysql , - wordpress - sql php - mysql , - ) wpdb php - phpmyadmin - latin1_swedish_ci wordpress - mysql - mysql - mysql - mysql - mysql - - mysql - php - php utf8 - mysql - convert_to_utf8_sql_generator.txt - - wordpress , - wordpress - wordpress - - php - wordpress - UTF8 - MySQL - utf-8 mysql php - wordpress - mysql , - mysql - mysql " = can ) FULLTEXT " - wordpress sets - mysql - - latin1_swedish_ci utf8 -