|
|
Posted by martin.wong on 11/28/92 11:59
Hi,
sorry if this is too rudimentary.
I've got an ASP page with CODEPAGE=932 setup as a form. Encoding is
SHIFT_JIS
In it, the user will put in some details in Japanese and submit
Another page will accept it via the Request.Form("") method and then
construct an SQL query statement...
like the following
SQL = "insert into tablename values ('" & request.form("var1") & "','"
& .....
It'll then attempt to insert into a database via ADODB
conn.execute(SQL)
Problem with this is when I try to display from database on an ASP page
(via CODEPAGE=932 and SHIFT_JIS), the display turns out to be ??????
question marks. Normally, if I screw up on a encoding thing, it'll come
up with some sort of gibberish, but this time round, it is ????
Going direct using SQL query analyzer shows up as ???? so it can be
concluded that it is stored as ????? in the database.
Database is MSSQL2000 with collation of SQL_Latin1_General_CP1_CI_AS
Not sure if the collation is the primary culprit but any pointers and
suggestion is much appreciated.
Rgds,
Martin
Navigation:
[Reply to this message]
|