Re: How to Insert Chinese into Mysql database with ASP
Posted by: Chetan Patel
Date: September 22, 2005 07:58AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: How to Insert Chinese into Mysql database with ASP
4291
September 22, 2005 07:58AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.