Variable with Chinese characters

[Eins via DotNetMonster.com]

Dear all;

I have the following code:

Dim Remark
Remark = Request.Form("Remark")


sql = "INSERT INTO TblTestTable " _
& "(Comment) " _
& "VALUES (N'" & Remark & "')"
dbconn.open()
dbcomm=New OleDbCommand(sql,dbconn)
dbcomm.ExecuteNonQuery()
dbconn.Close()

txtDisplay.text = "The remark posted: " & Remark


When I write into my database with N'" & Remark & "' the Chinese
characters are stored into my database correctly.
However, when I try to display what I have in my variable (Remark), all I get
is ???

How can I solve this?

Please help.

Thank you.

PS:
I am doing my coding with VB ASP.net.
My database is MS SQL 2000

 

[John Rivers]

have a look at:

http://support.microsoft.com/defaul...&sd=rss&spid=6351#XSLTH4170120122120121120120

how do you ???? look in html? that will give a clue

does your browser machine have "ms arial unicode" font installed?

that is the universal font which supports all languages

you aren't changing the response encoding forom UTF8 are you?