Hi all,
I have to chose the best Data Access Component with SQL Server Express edition.
The application that I am going to develope is a simple one but the speed should be as much as possible.
Any help would be highly appreciated.
Thanks & regards
Arun Gupta
The 'best' speed would most likely be attained using the SQL native client and a datareader object.hi,
I want to migrate from MYSQL to MSSQL 2005. My website Contains Multilangugal contents "Frace & Arabic". I 'm using "UTF_8 generalCI" Collation in MYSQL . What Collation I should use in MSSQL 2005. I only want to have One DB.
thanks,
Inorder to store multi-lingual text, you need to set the field datatype to NVARCHAR. This should work fine. If you need more information, let me know. I am currently working on an arabic web portal.
Thanks
|||thanks for your Rply,
I've set field types as nvarchar. But If I set collation as "latin1swedish" and field as nvarchar then I can't find Arabic words.. would you please tell me, what is the role of collation in DB. suppose
would you please tell me what method are you using for Arabic website developement.Do you use 2 Seprate DB? hae you create arabic section as a real subweb or you use methods like profile.
best regards,
|||Hi,
The collation is used when sorting and querying. When sorting, SQL Server will sort according to the selected collation.
You can alter a column's collation by using the COLLATE clause. Please check the following link for more information.
http://msdn2.microsoft.com/en-us/library/ms184391.aspx
|||thanks Kevin for your reply,If I've understood right, I could enter multi languagual contents to NVARCHAR fields, and Collation doesn't matter while save data.We could change the DB Colation later if needed.But what is the usual Collation. ex. what www.asp.net uses for it's collation. regards,