Re: Russian Language support in SQL SERVER

From: Alan Brewer [MSFT] (alanbr_at_microsoft.com)
Date: 02/23/04


Date: Mon, 23 Feb 2004 10:34:17 -0800

SQL Server supports languages on a couple of levels.

First, specifying a collation defines what language rules are used for
storing data and identifiers (identifiers are the names of database objects
such as tables, views, stored procedures). SQL Server 2000 includes a
Cyrillic_general Windows collation that supports the Russian language. If
you specify that collation as the default collation during setup, all of the
databases will support Russian data and identifiers. You can also specify a
collation when creating a database or even at the column level.

Second, there are localized versions of SQL Server in which the
documentation, help, user interface, and error messages have been translated
into a language. SQL Server 2000 has not been localized to Russian, so you
cannot get a version of SQL Server where the docs, help, UI, and error
messages are in Russian. However, you can store the user data in Russian by
specifying the Cyrillic_general collation during setup, or when creating a
database or tables.

If you would like to see a future release of SQL Server that is fully
localized into Russian, please email sqlwish@microsoft.com.

There is more information on collations here:

http://msdn.microsoft.com/library/?url=/library/en-us/architec/8_ar_da_6ttf.asp?frame=true
http://msdn.microsoft.com/library/?url=/library/en-us/instsql/in_collation_72pg.asp?frame=true

-- 
Alan Brewer [MSFT]
Lead Programming Writer
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights


Relevant Pages

  • Re: DateTime Format in Localized version of MSDE
    ... You are right that datetime and smalldatetime in SQL Server are stored in ... a binary, language-neutral format. ... deleting depends on the language setting for the connection, ... collation is irrelevant for datetime. ...
    (microsoft.public.sqlserver.msde)
  • Re: collation setup
    ... Language settings are not the same thing as collations. ... If you set the Server Default language to British and change the language ... regardless of your collation setting. ... Jasper Smith (SQL Server MVP) ...
    (microsoft.public.sqlserver.setup)
  • Re: how does ado.net SqlDataReader.GetString() know which encoding to read the
    ... data into a string as? ... In SQL Server, you can define collation on column level. ... use the Current Language property. ...
    (microsoft.public.sqlserver.datamining)
  • Re: General .Net Question
    ... I contend very difficult to just jump in and learn, and the SQL Server ... development using Java. ... A/E/C Consulting, Web Design, e-Commerce Software Development ... >> Language Specification). ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: FTS for particular language
    ... John, ... installed SQL Server with Arabic or Latin collation. ... While your default FT Language ... >> regardless of Arabics). ...
    (microsoft.public.sqlserver.fulltext)