SQL Server Performance Forum – Threads Archive
How to handle Arabic language?Hi, I’m not familiar with unicode and code page. I’m confused about code page and collation. In order to save data in arabic in SQL Server 2000, what are the requirements? Requirements that I can think of:
1. Does the machine require a specific language version of Windows OS?
2. Does it require setting something in Regional and Language options?
3. Does it require SQL Server to be installed with a specific collation? Additional information: 1. Both databases and tables are created without specifying collation.
2. Columns of all tables are not unicode data type.
May check these KBAs
http://www.novicksoftware.com/UDFofWeek/Vol1/T-SQL-UDF-Volume-1-Number-52-udf_TxtN_SingleSpace.htm HTH Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.