Showing posts with label SQL Server Tips. Show all posts
Showing posts with label SQL Server Tips. Show all posts

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'%សន%'