Greek Alphabets in SQL Server 2000

  • Noor2677

    Valued Member

    Points: 59

    Dear All,

    Can anybody please guide me on how to Insert Greek Alphabets in SQL Server 2000.

    Best Regards,

    Noor

  • Adi Cohn-120898

    SSC-Dedicated

    Points: 33944

    You have 2 choices. The first choice is to use Unicode instead of ASCII (e.g. nvarchar or nchar instead of varchar or char). If you use Unicode, then you can work with many languages instead of limiting yourself to 2 languages. The down side is that each character is stored with 2 bytes instead of 1 byte. The second choice is to install your server using one of the Greek collations. If you use this choice, you’ll be able to use ASCI characters to store Greek or English, but if you’ll need to store another language (for example Arabic), you’ll still have to use Unicode.

    Adi

    --------------------------------------------------------------
    To know how to ask questions and increase the chances of getting asnwers:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

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

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