Arabic as a default language in SQL server 7.0

  • Arabic is not provided in SQL server 7.0 as a default language, I can't insert retrieve arabic text from my interface enviroment (such as Power Builder) through an ODBC. it can be done with SQL server 2000 when I set the Arabic as the default language, but how can I do it in SCL server 7.0? any one can help me?

  • I am not 100% on this but I believe it is correct and you should be able to validate thur setting up a test copy on a small machine.

    With SQL 7 the server is based on one code page. To have Arabic available you need to install SQL 7 with code page 1256. However if you need other languages too, then use instead code page 850 Multilingual.

    Note from BOL

    quote:


    Important: It is critical that you select the correct character set when you install SQL Server. To change character sets after installing SQL Server, you must rebuild the databases and reload the data.


    See BOL for more on COde Page, Character Set and Unicode Collation.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply