Problem with thai language utf-8

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • OriginalT
    New Member
    • Oct 2012
    • 3
    • 4.2.X

    Problem with thai language utf-8

    Problem with thai language utf-8

    testing in vbulletin 4.2.0 and 5.0 beta 14 it the have same problem
    ex. http://www.vbulletin.com/vb5demo/for...=5152#post5152

    I have solved the problem as follows. but it still same problem please tell me how to fix it.

    thanks.

    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:

      // ****** 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:


      Code:

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

    Attached Files
  • Wayne Luke
    vBulletin Technical Support Lead
    • Aug 2000
    • 73976

    #2
    And what is the character set and collation of your database?

    Did these characters work properly before upgrading?
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API

    Comment

    • OriginalT
      New Member
      • Oct 2012
      • 3
      • 4.2.X

      #3
      Originally posted by Wayne Luke
      And what is the character set and collation of your database?

      Did these characters work properly before upgrading?
      1. character set and collation of your database >>> utf8_unicode_ci
      2. new install not upgrading

      • Server: Localhost via UNIX socket
      • Software: MySQL
      • Software version: 5.5.27-log - MySQL Community Server (GPL)
      • Protocol version: 10
      • User: hosttha1@localhost
      • Server charset: UTF-8 Unicode (utf8)


      • Apache/2
      • Database client version: libmysql - 5.5.27
      • PHP extension: mysqli


      best regards

      Comment

      • Wayne Luke
        vBulletin Technical Support Lead
        • Aug 2000
        • 73976

        #4
        Originally posted by OriginalT
        1. character set and collation of your database >>> utf8_unicode_ci
        utf8-unicode-ci is the collation. It only tells MySQL how to sort stored data when using order by in queries. This is different from a character set which tells MySQL how to actually store the data.

        The database character set can be different from the default server character set in MySQL.
        Translations provided by Google.

        Wayne Luke
        The Rabid Badger - a vBulletin Cloud demonstration site.
        vBulletin 5 API

        Comment

        • OriginalT
          New Member
          • Oct 2012
          • 3
          • 4.2.X

          #5

          Update: Problem solved. Thanks for the response.





          Click image for larger version

Name:	1.jpg
Views:	1
Size:	62.3 KB
ID:	3690591Click image for larger version

Name:	2.jpg
Views:	1
Size:	103.0 KB
ID:	3690592Click image for larger version

Name:	utf8.jpg
Views:	1
Size:	88.0 KB
ID:	3690593

          please see in attached file. sorry I'm not good at English.
          Last edited by OriginalT; Wed 24 Oct '12, 11:51pm.

          Comment

          Related Topics

          Collapse

          Working...