Re: How to Insert Chinese into Mysql database with ASP

[Tetsuro Ikeda]

hi Chetan,

There is 2 possibiliy that your chinese characters is converted to question mark.

1. the Table (and the column) 's charset may still latin1, and so your characters are converted to
question mark when server executing the INSERT.
Let's check it by using "DESC tablename" and what charaset is used for your table.

2. the connector you are using may insert the characters as latin1 when sending the
data to server (before server execute the INSERT)
if so, you can change this by using properties for conector so that the connector
can insert the character correctly.
the way for setting the connector depends on what connector you using.
But you can check if how your connector put the characters into server by checking
mysql general log like the following

---
2 Connect @localhost as anonymous on test
2 Query SET NAMES utf8
2 Query SET character_set_results = NULL
2 Query SHOW VARIABLES
2 Query SHOW COLLATION
2 Query SET autocommit=1
---
See the "SET NAMES XXX"
In this case (Connector/J), the connector put the data as utf8