Hi,

I'm making a translation thingie, that contains several languages. One of
them is Danish and in one of my update scripts, I've come upon something
strange.
I have a text containing the letter "å" which is a special Danish letter
(along with ø and æ). When I create the data base and inserts the default
data everything is fine. But if I use an update script like:

UPDATE [dbo].[TextControlLanguage]
SET [Text] = 'Skabelonen er måske ikke gemt. Vil du gemme den?'
WHERE TextControlID = 1217
AND LanguageID = 1

the "å" in "måske" gets lost. Do I have to some alpha nummeric code?
How come that when inserting the default data everything is fine, but when
updating the "å" is removed?

/Hansen

[quoted text, click to view]

It turned out that it was the code that read the sql from a text file that
removed the special characters

/Hansen