SQL Server Special Characters Sort By

62 views Asked by At

I want to sort using SQL_Romanian_CP1250_CS_AS and as a result I get:

Du
Șe
Ge

Which should be

Du
Ge
Șe

I think that it ignores the special character and I don't know why.

I try different Fonts, Encoding, Collates and even some of the Locale/Language Pack unicode like if I try to insert in without an N in front of string like "Șe" instead of N"Șe" I get "?e", but if I try "ă" it is inserted correctly. As I enter manually the row, it is inserted corrected.

0

There are 0 answers