|
Posted by Hansen on 10/02/14 11:53
> 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?
It turned out that it was the code, that read the sql form a text file that
removed the special characters.
/Hansen
[Back to original message]
|