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.
Thanks, Peter

May check these KBAs
http://support.microsoft.com/default.aspx?scid=kb;en-us;322112
http://support.microsoft.com/default.aspx?scid=KB;en-us;q232580
http://www.novicksoftware.com/UDFofWeek/Vol1/T-SQL-UDF-Volume-1-Number-52-udf_TxtN_SingleSpace.htm HTH Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>