Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Greek Alphabets in SQL Server 2000 Expand / Collapse
Author
Message
Posted Monday, February 7, 2011 9:35 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, February 8, 2011 8:55 PM
Points: 1, Visits: 2
Dear All,

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

Best Regards,
Noor
Post #1060017
Posted Tuesday, February 8, 2011 1:14 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, September 24, 2014 3:12 AM
Points: 2,112, Visits: 5,480
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/
Post #1060066
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse