i'm using SQL Server 2008 R2 Latin1_General_CS_AS collation on database.
I need to load data from Latvia and Estonia. When i select data from loaded table i can see correct results. But when i am using WHERE condition to search record then it can't be found. For example:
select 'Value: ÕÜä'
These are Estonia symbols. And in Management Studio i can see what i have selected. But with Latvian is different
select 'Value: IRIELŠ'
Management Studio returns Value: IRIELŠ
As you can see result is not the same. Maybe anyone know what Collation i should use, that everything would work fine?
EDIT: Tried use WHERE column = N'IRIELŠ' and then found.
But it is not good use N symbol between each string..
View Complete Post