SQL Server Comparing Cyrillic Characters with Latin ones
Posted on 2007-11-19
I have a table (AlphabetTable) with the following columns:
I want to query like this:
select GermanCharacter from AlphabetTable where RussianCharacter = 'ÃƒÂÃ‚Â¸'
My SQL Server has the following collation: Latin1_General_CI_AS
My query always returns no rows even though all the Russian characters are entered into the table. This is for a very basic function that translates a customer name entered in Cyrillic.
Assistance would be greatly appreciated.