Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to insert Thai language Expand / Collapse
Author
Message
Posted Thursday, November 27, 2008 7:08 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, August 20, 2013 3:01 AM
Points: 6, Visits: 30
Hi,

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 advance
Post #610028
Posted Thursday, February 19, 2009 2:39 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 2:32 PM
Points: 3,428, Visits: 14,439
Thai 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.


http://msdn.microsoft.com/en-us/library/aa258233(SQL.80).aspx

http://msdn.microsoft.com/en-us/library/aa176553(SQL.80).aspx



Kind regards,
Gift Peddie
Post #660887
Posted Monday, April 13, 2009 12:18 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, August 22, 2009 1:06 AM
Points: 3, Visits: 5
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
Post #696028
Posted Monday, April 13, 2009 12:22 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, August 22, 2009 1:06 AM
Points: 3, Visits: 5
This 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 :)
Post #696035
Posted Friday, August 21, 2009 7:10 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, August 21, 2009 7:12 AM
Points: 4, Visits: 4
It is a critical thing to insert thai language. It has similarity as arabic language.

Buy Magic Jack
Post #775020
Posted Saturday, August 22, 2009 1:11 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, August 22, 2009 1:06 AM
Points: 3, Visits: 5
What 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.Load
Response.Charset = "tis-620"
End Sub

2) 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)

Post #775517
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse