Hi Jerry,
If I use "INSERT INTO ...", the error message is :
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in string in query
expression '''. /oa/send.asp, line 199
If I use "response.write" to track the sql string, I found the string was
terminated by the first of the Chinese Char(no Chinese Char can be read)
like this:
The Original SQL string:
INSERT INTO Table1(Field1, Field 2) VALUE('" & FieldValue1 & "', '" &
MyChineseWords & "')"
I got this result:
INSERT INTO Table1(Field1, Field 2) VALUE('abc', '
which the second field is my Chinese Char. No idea why the string
terminated.
If I use "rs.AddNew...." no error message and only a null value saved in the
table. I use "response.write" to
track the value before save to the table, it's still empty.
Lokks like the value MyChineseWords has some symbol and the system think
it's the end of string. I get MyChineseWords from a text form area that
input by user. There is no problem which English Charactor, only in Chinese.
hao
"Jerry III" <je******@hotmail.com> wrote in message
news:Ob**************@tk2msftngp13.phx.gbl...
How about posting those errors you were getting? We're not psychic...
Jerry
"hao" <ph******@hotmail.com> wrote in message
news:eR**************@TK2MSFTNGP09.phx.gbl... Hi, all
When I use ASP to insert an record to a database, I got
some errors and can not insert any value with Chinese Char.
The only way I can do that is use "rst1.Addnew...rst1.update".
Anyone know why?
thx
hao
