How to use ORDER BY, LOWER .. in SQL SERVER 2008 with non-unicode data
Posted
by hgulyan
on Stack Overflow
See other posts from Stack Overflow
or by hgulyan
Published on 2010-03-30T05:39:48Z
Indexed on
2010/03/30
6:03 UTC
Read the original article
Hit count: 392
sql-server
|non-unicode
Hi,
The question is about Armenian. I'm using sql server 2005, collation SQL_Latin1_General_CP1_CI_AS, data mostly is in Armenian and we can't use unicode.
I tested on ms sql 2008 with a windows collation for armenian language ( Cyrillic_General_100_ ), I have found here, ( http://msdn.microsoft.com/en-us/library/ms188046.aspx ) but it didn't help.
I have a function, that orders hex values and a lower function, which takes each char in each string and converts it to it's lower form, but it's not acceptable solution, it works really slow, calling that functions on every column of a huge table.
Is there any solution for this issue not using unicode and not working with hex values manually?
© Stack Overflow or respective owner
