Foreign characters lose their diacritics

Question

I'm trying to internationalize the questions in our survey-tool, but when I insert some translated strings, SQL-server seems to strip of some, but not all, diacritics...

Example: (Lithuanian)

Ar jūsų darbas reikalauja, kad jūs įgytumėte naujų žinių ir įgūdžių?

Becomes

Ar jusu darbas reikalauja, kad jus igytumete nauju žiniu ir igudžiu?

Notice the 'z' has kept its diacritic, while the 'u', 'i' and 'e' has lost theirs. The table column that keeps the text is nvarchar, however the table collation is 'Danish_Norwegian_CI_AS'.

Any suggestions?

EDIT 2010.08.16 11:17:

Ok. I might have narrowed something down. It seems that the stored procedure I use to extract the sentence from the db is the one performing the stripping. It selects from several sources, all of which are nvarchar using a UNION to get everything into the same query. Somewhere in there the characters are stripped.

... Hold on... I think I might have fracked up something along the way...

Answer 1

The collation settings won't affect data stored in columns of type UTF-8. I would change the codepage and encoding of your file to UTF-8, and ensure that your table is storing text as UTF-8, and you should be all set.