Learn to share

http://computer-experience.blogspot.com/2008/12/khmer-unicode-with-crystal-report-in-c.html http://sochinda.wordpress.com/2009/10/07/print-crystal-report-with-khmer-unicode-in-c-application/

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

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 + ...