Language / Charset Problems - Things To Check

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Jake Bunce
    Senior Member
    • Dec 2000
    • 46598
    • 3.6.x

    [Any Version] Language / Charset Problems - Things To Check

    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:

      Code:
      	//	****** 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 latin1, 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.
      [color=red]// $config['Mysqli']['charset'] = 'utf8';[/color]
      _____
    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:



      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:



      Note their example:

      Code:
      mysqldump refbase -u root -p --opt [color=red]--default-character-set=latin1[/color] > refbase.sql

Related Topics

Collapse

Working...