Khmer Unicode in SQL 2008,

-
    I have been taking a while for searching for feasibility to use Khmer Unicode in SQL Server. Recently I have found article posted by sochinda related to how to be able to use in SQL Server.


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

Comments

Post a Comment

Popular posts from this blog

How to prevent a user from running Task Scheduler in Windows

-
Prevent users from adding new tasks or deleting tasks in Task Scheduler by modifying local policy settings Note   The following procedure only applies to Windows XP Professional, Windows Server 2000, or Windows Server 2003. To do this in Windows XP Home edition, see the "Prevent users from adding new tasks or deleting tasks in Task Scheduler by modifying registry settings" section of this article. Log on as Administrator to the computer where you want to modify the Local Policy settings. Click  Start , and then click  Run . In the  Open  box, type  gpedit.msc  , and then click  OK . In the left pane of the console, expand the  Computer configuration  node. Expand  Administrative Templates , and then expand  Windows Components . Click  Task Scheduler . In the Task Scheduler pane, do the following: Double-click  Prevent Task Run or End . Click  Enabled , and then click  OK . Double-click  P...
Read more

Reading excel file in asp.net

-
The followiing are that code that I have used to read excel file: DataSet myDataset = new DataSet(); if (!FullFileName.Equals("")){ OleDbConnection conn = new OleDbConnection(); OleDbCommand cmd = new OleDbCommand(); OleDbDataAdapter da = new OleDbDataAdapter(); string query = null; string connString = ""; string strFileType = System.IO.Path.GetExtension(FullFileName).ToString().ToLower(); if (strFileType.Trim() == ".xls"){ connString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + FullFileName + ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=2\""; } else if (strFileType.Trim() == ".xlsx"){ connString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + FullFileName + ...
Read more