Russian collation must use Cyrillic? True or false

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Russian collation must use Cyrillic? True or false

Author

Topic

madlo
Starting Member

41 Posts

Posted - 2009-03-02 : 05:53:37

I am at a site that uses Russian and english language text characers in SQL 2005 database and created a database with Latin1_general_bin with our company application which is the standard collation I usually use.
Russian texts gets stored correctly and get no issues. Applciation also stores and saves Russian characters in char fields correctly.

However Russian office told me sooner or later site will get issues and I need to rather create Cyrillic_CS_AS or I will get ?????? in Crystal Reports which I was unable to simualte as Crystal gave me the correct Russian language.

Must one use Cyrillic for Russian language and how will this differ as I couldn't get it to show any adverse affects.

heavymind
Posting Yak Master

115 Posts

Posted - 2009-03-02 : 06:14:09

hi madlo.
You will get issues if you use non-unicode character types.
another issue lies in sort order
for instance
declare @a table ( t nvarchar(10) collate Latin1_general_bin)
insert @a
select '?'
union all select '?'
union all select '?'
union all select '?'
union all select '?'
union all select '?'
union all select '?'
union all select '?'
union all select '?'
select * from @a order by t

letter '?' goes after '?' in russian alfabet but it is shown last

Thanks, Vadym
MCITP DBA 2005/2008
Chief DBA at http://www.db-staff.com

heavymind
Posting Yak Master

115 Posts

Posted - 2009-03-02 : 06:17:32

as you see this forum database use non-unicode character types in the backend :)
I hope you understand the sort order issue ...

Thanks, Vadym
MCITP DBA 2005/2008
Chief DBA at http://www.db-staff.com

madlo
Starting Member

41 Posts

Posted - 2009-03-02 : 06:49:15

???????.

madlo
Starting Member

41 Posts

Posted - 2009-03-02 : 06:50:26

Sorry tried to type in Russian text but it got translated to ?????.

Sorting would be reason enough. Thanks.

Ciwan21
Starting Member

7 Posts

Posted - 2009-03-22 : 07:45:04

hi there,
Iam doing localisation on VB.NET and using SQL Server 2000. after putting the table in sql, for translation some of the html pages but sql server doesn't take russian letters in the table. As i have done it for finnish (findlan language) and with it sql server does it without problem. could anyone tell me what's wrong with it, why sql does not the letters instead of showing ?????? ?
Thanks

finding out is better

arjandalipi
Starting Member

1 Post

Posted - 2009-05-28 : 12:50:09

I did understand your problem well but anyway i am gonna say something:

if you need to save data in cyrillic you have to do the following:

1.set the atribute type to ntext,

2.set the collation of the atribute to (collation you want exeple:MACEDONIAN ect)

3.now when you insert cyrillic you need to add N'APAC' exaple

insert into tblClient (name) values (N'APAC')

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources