Language / Charset Problems - Things To Check

[thxf.org]

Some people encounter problems with garbled characters when using vBulletin with non-English languages. Here are some things you can check based on my experience troubleshooting these problems:

1. Make sure your HTML charset is appropriate to your forum language:
   
   Admin CP -> Languages & Phrases -> Language Manager -> [Edit Settings] -> HTML Character Set
   
   _____
2. Also try emptying the blank character stripper:
   
   Admin CP -> vBulletin Options -> Censorship Options -> Blank Character Stripper
   
   _____
3. Also, the line wrapper can sometimes cause problems with multi-byte languages:
   
   Admin CP -> vBulletin Options -> Thread Display Options (showthread) -> Number of Characters Before Wrapping Text
   
   _____
4. Also, the "prevent shouting" feature can cause problems for some non-English languages. Try disabling it:
   
   Admin CP -> vBulletin Options -> Message Posting and Editing Options -> Prevent 'SHOUTING'
   
   _____
5. You might also need to set the MySQL charset in your includes/config.php file by uncommenting this line. This setting was added starting with 3.5.x:
   
   

   // ****** MySQLI OPTIONS *****
   // When using MySQL 4.1+, MySQLi should be used to connect to the database.
   // If you need to set the default connection charset because your database
   // is using a charset other than utf8, you can set the charset here.
   // If you don't set the charset to be the same as your database, you
   // may receive collation errors. Ignore this setting unless you
   // are sure you need to use it.
   $config['Mysqli']['charset'] = 'utf8';

   _____
6. Also make sure your database collations are appropriate and consistent throughout the entire database. You need to use program like phpmyadmin to view your collations:
   
   http://www.phpmyadmin.net/home_page/index.php
   
   When you click your database name in phpmyadmin it will list all tables, their collations, as well as the collation of the database itself at the bottom. And when you click the name of a table on the left it will list the collations of individual fields within that table.
   
   1) To edit the collation of the database itself you need to click the database name on the left and then click "Operations" on the top.
   
   2) To edit the collation of an individual table you need to click its name on the left and then click "Operations" on the top.
   
   3) To edit the collation of an individual field within a table you need to click the table name on the left and then click the edit image (a little pencil icon) for that field.
   
   _____
7. If there was a database move involved then you might need to specify the character set when making the dump. This guide shows how:
   
   http://wiki.refbase.net/index.php/Troubleshooting
   
   Note their example:
   
   
   

    mysqldump refbase -u root -p --opt --default-character-set=utf8 > refbase.sql

ปล. ภาษาไทย utf8 tis620 ใช้ได้หมดครับ :byeby

 

[izeebit]

ขอบคุณครับ

 

[awinzenon]

ไม่เข้าใจข้อนี้อ่ะครับ
If there was a database move involved then you might need to specify the character set when making the dump. This guide shows how:

http://wiki.refbase.net/index.php/Troubleshooting

Note their example:

 

[vojo]

ขอบคุณคุณ Admin ที่ให้คำแนะนำที่เป็นประโยชน์ทั้งทางเวปไซท์แห่งนี้และทางโทรศัพท์นะครับ เป็นคนดีจริงๆ ขอบคุณอีกครั้งครับ

 

[osix]

Thanks for Great Info 🙂