Re: How to Insert Chinese into Mysql database with ASP
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
鼎繁
please advice
Subject
Views
Written By
Posted
9686
May 24, 2005 01:59PM
4324
May 25, 2005 11:31AM
4138
May 25, 2005 11:33AM
2974
May 25, 2005 11:36AM
2899
September 19, 2005 02:13PM
5456
September 21, 2005 03:05AM
Re: How to Insert Chinese into Mysql database with ASP
4291
September 22, 2005 07:58AM
2877
September 28, 2005 03:34PM
2775
September 28, 2005 03:42PM
6104
September 29, 2005 08:42PM
2810
November 24, 2005 08:36AM
2781
December 01, 2005 06:35AM
2699
October 13, 2006 09:50AM
2800
January 26, 2006 01:34AM
3943
January 26, 2006 01:50AM
5061
February 23, 2006 08:22AM
5492
June 14, 2006 01:05PM
2912
August 09, 2006 07:27AM
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.