Dear Nant,

I really appreciate your pointing me to directions to fix this. After googling up with results. It appears that I need to set the following at the configuration file that is read when MySQL starts:

[mysql]
default-character-set=utf8

How can I modify the configuration file at Phpmyadmin?

Viewing "Server variables and settings" at phpmyadmin. It shows that:

"character sets latin1 big5 czech euc_kr gb2312 gbk latin1_de sjis tis620 ujis dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5"

Is this what you mean by the string that is currently being used?

Hi,

I executed following command:
ALTER TABLE (TABLES) CHARACTER SET utf8;

for each of the following tables:

mos_components
mos_comprofiler
mos_comprofiler_conditions
mos_comprofiler_fields
mos_comprofiler_field_values
mos_comprofiler_lists
mos_comprofiler_members
mos_comprofiler_plugin
mos_comprofiler_tabs
mos_comprofiler_userreports
mos_comprofiler_views

But, when I view the details.. Japanese is still not displayed properly..

I tried to execute ALTER DATABASE command as described at dev.mysql.com/doc/refman/5.0/en/charset-database.html but I get error message of

"#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DATABASE databasename CHARACTER SET utf8' at line 1 " It's likely that is due to MySQL version difference.

Can you please advice me what else to do to solve the encoding issue?

Post edited by: Kayenumb, at: 2006/07/03 17:33

Hello!
I like to thank you for all the help and providing the link to the informative article. I want to share that the language display problem is solved!

My MySQL version is 4.0, does not support utf-8 encoding, but the problem is solved after I upgraded CB from RC2 to Stable 1.0!!

Yay!!