Hi,

I have written some pages in asp.net and i use adodb to enter into a MSSQL 2000 database.

I made a form and i can enter thai characters in it.

I use to following to enable thai characters

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

Response.Charset = "tis-620"

End Sub

Now I enter thai into a textfield (??? is my text and the form field is named xlate) and i do a request.form and I get ??? back and i write it on the screen. Happy so far.

Now I use the following to update into the database:

objConn.Execute("Update tl_translate Set tl_th = '" & Request.Form("xlate") & "' Where tl_id = " & Request("tl_id"))

I get a ? in the database and when i write the database value on the screen (webpage) i get a ? too.

I made the field in the database a nvarchar and use Thai_CI_AS collation.....

If someone can tell me where i go wrong..I will give him/here a cookie 🙂