About ZH Problems.

[Migrated From Jforum.net]

Web Container:Tomcat 5.5
DB: Mysql -4.22

can not process chinese?

in db appear "??"

How I can resolve this?

such as:

???
[originally posted on jforum.net by huhpreal]

[Migrated From Jforum.net]

Change the character set of your tables to UTF-8. You can do that by typing the following command in the mysql console:

ALTER TABLE tbl_name CONVERT TO CHARACTER SET utf-8;

Rafael
[originally posted on jforum.net by Rafael Steil]

[Migrated From Jforum.net]

Thanks,
But 'ALTER TABLE tbl_name CONVERT TO CHARACTER SET utf-8'
is an unkown command;
[originally posted on jforum.net by huhpreal]

[Migrated From Jforum.net]

Message:
mysql> ALTER TABLE tbl_name CONVERT TO CHARACTER SET utf-8
-> ;
ERROR 1064: You have an error in your SQL syntax near 'CONVERT TO CHARACTER SET
utf-8' at line 1
[originally posted on jforum.net by huhpreal]

[Migrated From Jforum.net]

I have resolved the question,
anyway thank you!
[originally posted on jforum.net by huhpreal]