We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 45900
    • 53 Posts
    I have made 3 languages for my site which are: English as default, Danish and Thai.
    There is no problem on Danish language (I can use Scandinavian characters). However, when I switched to Thai. I typed in Thai from content field. What modx render on the web page became '????'.

    I have searched through the forum and learned that I need to set the database to be utf8. So I have checked my phpmyadmin page and found out that it has already been set to utf8

    I also checked my config file which you will see bellow:
    <?php
    /**
    * MODX Configuration file
    */
    $database_type = 'mysql';
    $database_server = 'thaicom.dk.mysql';
    $database_user = '###';
    $database_password = '###';
    $database_connection_charset = 'utf8';
    $dbase = 'thaicom_dk';
    $table_prefix = 'modx_';
    $database_dsn = 'mysql:host=thaicom.dk.mysql;dbname=thaicom_dk;charset=utf8';


    I don't know what to do next in order to have thai language worked. Please suggest.


    Joy
    • What do you get in the Manager for the resource content? Does it appear correctly there?
        Studying MODX in the desert - http://sottwell.com
        Tips and Tricks from the MODX Forums and Slack Channels - http://modxcookbook.com
        Join the Slack Community - http://modx.org
        • 45900
        • 53 Posts
        No it doesn't appear correctly. it's also shown like this '????'
        • Take a look at the text fields in the site_content table in the database. You may find that they have a collation other than utf8.
            Studying MODX in the desert - http://sottwell.com
            Tips and Tricks from the MODX Forums and Slack Channels - http://modxcookbook.com
            Join the Slack Community - http://modx.org
            • 45900
            • 53 Posts
            I browsed to site_content table and I can change only 2 rows to be utf8 which are 'type' and 'content type'. When I tried to change other rows I have got this notification error '#1283 column 'longtitle' cannot be part of fulltext index'
            • See this http://bobsguides.com/convert-db-utf8.html

              Be sure to read the instructions carefully.
                Studying MODX in the desert - http://sottwell.com
                Tips and Tricks from the MODX Forums and Slack Channels - http://modxcookbook.com
                Join the Slack Community - http://modx.org
                • 45900
                • 53 Posts
                Great! thanks a lot. It works now.