Re: How to Insert Chinese into Mysql database with ASP

[Shuichi Tamagawa]

Chetan,

Let's see if it the server side configuration is OK before testing from ASP. Make sure that the values of character set are like below, before you create the table and insert the data.

mysql> show variables like 'char%';
+--------------------------+-----------------------------+
| Variable_name | Value |
+--------------------------+-----------------------------+
| character_set_client | big5 |
| character_set_connection | big5 |
| character_set_database | big5 |
| character_set_results | big5 |
| character_set_server | big5 |
| character_set_system | utf8 |
| character_sets_dir | C:\mysql\share\charsets\ |
+--------------------------+-----------------------------+

Above all, your client terminal (MS-DOS I guess?) have to support big5 encoding to display the character correctly.