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 |
|
SPriya
Starting Member
12 Posts |
 Posted - 2008-03-07 : 02:21:48
|
| Cany any one tel me The sql collation for KHMER(Cambodian) LangaugeThanks & Regards,Priya |
|
|
Arnold Fribble
Yak-finder General
1961 Posts |
Posted - 2008-03-07 : 04:20:28
|
| SQL Server 2008 will have Khmer_100_CI_AS etc., but I don't think there is a Khmer collation in earlier versions. |
 |
|
|
SPriya
Starting Member
12 Posts |
Posted - 2008-03-07 : 04:42:18
|
My database is in sql server 2000 & 2005. ...Is it anyway i can store khmer Language in 2000 & 2005 .... |
|
|
|
Arnold Fribble
Yak-finder General
1961 Posts |
Posted - 2008-03-07 : 05:40:35
|
quote:
Originally posted by SPriya
My database is in sql server 2000 & 2005. ...Is it anyway i can store khmer Language in 2000 & 2005....
In SQL Server 2005, you certainly should be able to successfully store any Khmer characters that were assigned a codepoint in Unicode 3.0. You can store them in any Unicode character column (nchar, nvarchar, and so on) irrespective of collation.In practice, you probably wouldn't have a problem with storing the extra Khmer characters assigned codepoints in Unicode 4.0.Where you're likely to start having problems is in comparing and sorting Khmer strings. That's what the Khmer-specific collation would be giving you. |
|
|
|
SPriya
Starting Member
12 Posts |
Posted - 2008-03-07 : 07:10:40
|
| Thanks for your reply......I have created table with nvarchar as data type and try to store khmer....The table is like thisEnglish Khmer-----------------------------------priya ?????test ????The same content when i copy paste in word file ,then its showing the fonts properlyEnglish Khmer-----------------------------------priya ?????test ????I think its storing the fonts...but some problem in display....(I have used Sql Management studio) |
|
|
|
|
|
|
sql collation for KHMER Langauge