Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
M2
Starting Member
22 Posts |
 Posted - 2003-10-30 : 21:45:04
|
| I am trying to use SQL Server to keep Thai information such as “¢ÍàªÔÃèÇÁ§Ò¹ Ê׺ÊÒ¹ÇѲ¹¸ÃÃÁä·Â »ÃÐླÕÅÍ¡Ãз§ 2546 ã¹ÇѹàÊÒÃì·Õè 8 ¾ÄȨԡÒ¹ 2546 µÑé§áµèàÇÅÒ 17.30 ¹. à»ç¹µé¹ä» ³ ºÃÔàdzÅÒ¹ÃÔÁ¹éÓËÍ»ÃЪØÁ¡Í§·Ñ¾àÃ×Í (APEC)”.I can insert above Thai sentence via the Enterprise Manager (Tableà Open Tableà Return All Rows) and DTS. However, I can’t paste/view that sentence via the Query Analyzer. Anyone please guide me on this. Thanks!M2 |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2003-10-31 : 00:37:03
|
| The magic is in the 'N's. INSERT INTO MyTable N'¢ÍàªÔÃèÇÁ§Ò¹ Ê׺ÊÒ¹ÇѲ¹¸ÃÃÁä·Â »ÃÐ'The N prefix to the quoted data instructs SQL that the data is 2byte characters.Sam |
 |
|
|
M2
Starting Member
22 Posts |
Posted - 2003-10-31 : 01:45:35
|
| but I cant even see the Thai under Query Analyzer.I paste the Thai in Editor, but I cant see Thai words:What I can see as following:INSERT INTO MyTableN'???????????',N'????????) ?????????????????',N'????'PLease guide, Thanks ! |
|
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2003-10-31 : 07:50:05
|
| It looks like you need to install the international language support for Thai perhaps ?Control Panel, Regional and Language Settings, Language tab. But surely you have this enabled already (you're in Malaysia - right)?Once the Language settings are done properly, the ??? you see in Query Analyzer will appear in the correct character set.Sam |
|
|
|
mohdowais
Sheikh of Yak Knowledge
1456 Posts |
Posted - 2003-10-31 : 12:28:19
|
What is the datatype of your column...varchar with Thai collation or nvarchar(Unicode)? The "N" prefix that Sam showed works only with nvarchar columns. If it is varchar, I suspect you might have to set the default codepage of your pc to Thai. You can set this from the Control Panel -> Regional Settings. This is because Query Analyzer's interpretation of a single-byte string depends on the default codepage of the machine, which must match the collation specified in the column providing the data.Owais
Where there's a will, I want to be in it. |
|
|
|
|
|
|
Thai under Query Analyzer ?