Re: How to Insert Chinese into Mysql database with ASP

[Chetan Patel]

Hi
I did alter and following my table

mysql> show create table test.table2;
+--------+---------------------------------
------------------------------+
| Table | Create Table
|
+--------+---------------------------------
------------------------------+
| table2 | CREATE TABLE `table2` (
`column1` varchar(255) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=big5 |
+--------+---------------------------------
------------------------------+
1 row in set (0.00 sec)


I used mysql odbc connector and program like:

<%response.Charset="utf-8"%>
<%=request.form("mydata")
%>
<%
Dim conn_mysql
Set conn_mysql = Server.CreateObject("ADODB.Connection")
Str = "Driver={MySQL ODBC 3.51

Driver};SERVER=127.0.0.1;DATABASE=test;charset=big5"
conn_mysql.Open Str

response.write "insert into table4 (column1)

values('"&request.form("mydata")&"') "

sql =conn_mysql.execute("insert into table2 (column1)

values('"&request.form("mydata")&"')")

%>

I see on mysql browser and values like
&#40718;&#32321;

please advice