• 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/