Monday, June 9, 2014

Khmer Unicode in SQL 2014

We need to have our database
  . Collation as SQL_Latin1_General_CP850_BIN
  . Defined fields as NChar, NVarchar, ...


When insert we need to use such syntax as :



insert into tblUser(Name) VALUES(N'សួស្តី')
insert into tblUser(Name) VALUES(N'វាសនា')
insert into tblUser(Name) VALUES(N'ស្រីអៀប')

And When we do some search we need to applied : 



select * from tblUser
where Name LIKE N'%សន%'

No comments:

Post a Comment