Re: How to Insert Chinese into Mysql database with ASP

[Chetan Patel]

HI
I did

mysql> SHOW CREATE TABLE test.table2;
+--------+----------------------------------------------------------------------
---------------------------------------------------------------------------+
| Table | Create Table
|
+--------+----------------------------------------------------------------------
---------------------------------------------------------------------------+
| table2 | CREATE TABLE `table2` (
`column1` varchar(255) character set utf8 collate utf8_unicode_ci default NULL

) ENGINE=MyISAM DEFAULT CHARSET=latin1 |
+--------+----------------------------------------------------------------------
---------------------------------------------------------------------------+

When i entered chinese character and retrieve it display ?????????????

what is wrong?