Dear professional people,
When I write a program to store the (Big5) Chinese characters �S�\�g��
into mysql database through the mysql ODBC driver,
the original chinese characters change into another characters �S��g��
in mysql database.
On the other hand, I have tried the program to store the (Big5) Chinese
characters into another database through another ODBC driver, it is correct.
The chinese characters remain the same.
Would you help me to solve the problem?
How-To-Repeat:
1. Create a table (named TestTb) in mysql database with the following fields
:
Field RecNum
Type INT
Length 4
Not Null
Extra auto_increment
Field DataField
Type CHAR
Length 20
2. Create mysql ODBC (named TESTODBC) which points to the database having
the above table.
3. Create an ASP program as follows:
<%@ Language=VBScript %>
<meta http-equiv="Content-Type" content="text/html; charset=Big5">
<%
set oConn = Server.CreateObject("ADODB.Connection")
oConn.Open "DSN=TESTODBC;UID=root;Password=;"
FieldContent = "�S�\�g��"
response.write "Input =" & FieldContent & "<br>"
sql = "insert into TestTb (DataField) values ('" & FieldContent & "')"
oConn.execute(sql)
sql = "select * from TestTb"
set oRs = oConn.execute(sql)
do while not oRs.EOF
response.write "RecNum=" & oRs("RecNum") & "<br>"
response.write "DataField=" & oRs("DataField") & "<br>"
oRs.movenext
loop
%>
4. run the ASP program to see the special result.
My contact email address is [EMAIL PROTECTED]
Thanks for help!
Best regards,
Henry.
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
