Post reply

sql server and arabic langage?

  • February 25, 2002 at 8:54 am

    #78252

    Did you know can sql server support arabic langage and how ?

    Otherwise, please send me any documentation or site adresses about sql server ?

    THANKS

  • February 25, 2002 at 9:16 am

    #424400

    http://www.microsoft.com/sql

    Yes, when you do an install of SQL Server you can choose the language and other aspects of the server settings.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

  • February 25, 2002 at 9:23 am

    #424401

    But this is not sufficient to set an retreive data in Arabic Langage.

    Did you know other solutions ?

    THANKS

  • February 25, 2002 at 9:49 am

    #424406

    Sorry I don't work with other languages. Hoepfully there is someone else who will post and I will look thou and see if I can find details and let you know.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

  • February 25, 2002 at 11:32 am

    #424426

    Does the client OS support the Arabic language set you are trying to use?

    K. Brian Kelley

    bkelley@sqlservercentral.com

    http://qa.sqlservercentral.com/columnists/bkelley/

    K. Brian Kelley
    @kbriankelley

  • February 25, 2002 at 2:15 pm

    #424445

    The best book is BOL.

    In SQL server 7, the code page must be set to 1256, the Arabic code page. In 2000, you can set the database collation to Arabic using ALTER DATABASE. Other things, use nchar, nvarchar or ntext as datatype.

    So far, I have been using the XP MUI package as a client and it displays character sets for other language nicely, including Arabic.

  • February 26, 2002 at 2:03 am

    #424471

    no the client OS doesn't support the Arabic language.

  • February 28, 2002 at 8:41 am

    #424639

    Can SQL SERVER support both arabic and frensh ?

    THANKS A LOT

  • February 28, 2002 at 8:44 am

    #424641

    Can SQL SERVER support both arabic and frensh ?

    THANKS A LOT

  • February 28, 2002 at 8:44 am

    #424640

    Can SQL SERVER support both arabic and frensh ?

    THANKS A LOT

  • February 28, 2002 at 8:45 am

    #424642

    Can SQL SERVER support both arabic and frensh ?

    THANKS A LOT

  • February 28, 2002 at 8:48 am

    #424643

    Can SQL SERVER support both arabic and frensh ?

    THANKS A LOT

  • February 28, 2002 at 10:40 am

    #424653

    Yes. However I think we forgot you have to setup the server with the proper code page see BOL

    Collation Settings in Setup

    Use the Collation Settings screen to modify default collation settings. Use the Windows Locale option to match collation settings in instances of Microsoft® SQL Server™ 2000. Use SQL Collations to match settings that are compatible with the sort orders in earlier versions of SQL Server.

    Windows Locale

    Change the default settings for Windows Locale (Windows collation) only if your installation of SQL Server must match the collation settings used by another instance of SQL Server 2000, or must match the Windows locale of another computer.

    Collation Designator

    Select the name of a specific Windows collation from the list, for example:

    Use Latin1_General for the U.S. English character set (code page 1252).

    Use Modern_Spanish for all variations of Spanish, which also use the same character set as U.S. English (code page 1252).

    Use Arabic for all variations of Arabic, which use the Arabic character set (code page 1256).

    Use Japanese_Unicode for the Unicode version of Japanese (code page 932), which has a different sort order from Japanese, but the same code page (932).

    For more information, see Windows Collation Designators.

    Sort Order

    Select Sort Order options to use with the Collation Designator selected. Binary is the fastest sorting order, and is case-sensitive. If Binary is selected, the Case-sensitive, Accent-sensitive, Kana-sensitive, and Width-sensitive options are not available. For more information, see Windows Collation Sorting Styles.

    SQL Collations

    The SQL Collations option is used for compatibility with earlier versions of Microsoft SQL Server. Select this option to match settings compatible with SQL Server version 7.0, SQL Server version 6.5, or earlier. For more information, see SQL Collations.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

  • March 1, 2002 at 12:51 am

    #424684

    thanks

  • March 1, 2002 at 12:52 am

    #424685

    what does mean Don't roll your eyes at me. I will tape them in place

    Thanks

Viewing 15 posts - 1 through 15 (of 20 total)

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