InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 18 Jun 2013 18:43:20 GMT20http://www.sqlservercentral.com/Forums/Topic610028-230-1.aspxWhat I find funny/wierd/stupid....There are two ways to make thai characters available on a webpage:1) Set the charset (code behind)Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.LoadResponse.Charset = "tis-620"End Sub2) In the meta tag (html)meta http-equiv="Content-Type" content="text/html; charset=windows-874">This should do the same, AFAIK, but it seems it dont. When i do 1) and make a form and submit that form, the characters get messed up. When I do 2) all works well.So you really need to do 2) and then use the right collation and insert statement to insert into you database. I think that it is funny/wierd/stupid that there is difference between 1) and 2)Sat, 22 Aug 2009 01:11:59 GMTmoes-1066295http://www.sqlservercentral.com/Forums/Topic610028-230-1.aspxIt is a critical thing to insert thai language. It has similarity as arabic language.[url=http://productreviewsby.me/magic-jack/]Buy Magic Jack [/url]Fri, 21 Aug 2009 07:10:44 GMTpavel0444ihttp://www.sqlservercentral.com/Forums/Topic610028-230-1.aspxThis seems to work....objConn.Execute("Update tl_translate Set tl_th = N'" & Request.Form("xlate") & "' Where tl_id = " & Request("tl_id")) I'll eat the cookie myself :)Mon, 13 Apr 2009 12:22:31 GMTmoes-1066295http://www.sqlservercentral.com/Forums/Topic610028-230-1.aspxHi,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 SubNow 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 :-)Mon, 13 Apr 2009 12:18:43 GMTmoes-1066295http://www.sqlservercentral.com/Forums/Topic610028-230-1.aspxThai is one of the right to left languages as Arabic so you need to define the column or table or database with Thai collation and Nvarchar/Nchar/Ntext data type.[url]http://msdn.microsoft.com/en-us/library/aa258233(SQL.80).aspx[/url][url]http://msdn.microsoft.com/en-us/library/aa176553(SQL.80).aspx[/url]Thu, 19 Feb 2009 14:39:37 GMTGift Peddiehttp://www.sqlservercentral.com/Forums/Topic610028-230-1.aspxHi,I need to insert Thai fonts thru insert SQL statement from query analyzer or thru ASP coding. If i insert, i see only junk characters (like ?????). If I copy and paste in to table from Enterprise manager i am able to see the Thai text clearly. Why this happens? any idea? How to solve this problem. anybody pls reply asap.Thanks in advanceThu, 27 Nov 2008 19:08:54 GMTcharan-703265