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:
* 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.
What do you get in the Manager for the resource content? Does it appear correctly there?
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.
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.
Great! thanks a lot. It works now.