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
-
☆ A M B ☆
- 24,524 Posts
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 '????'
-
☆ A M B ☆
- 24,524 Posts
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'
-
☆ A M B ☆
- 24,524 Posts
See this
http://bobsguides.com/convert-db-utf8.html
Be sure to read the instructions carefully.
Great! thanks a lot. It works now.