german umlaut signs false representation after read from SQL2000 database

[Nusret Bajric]

Hello,

I am programming asp.net site and I use the SQL-database connection
(SQL Server 2000 SP3) for reading my language data. I use "ntext" unicode
data type to store data in different languages. I read in my application
"ntext" field
into string variable. Strings are later written in one file. At the end I
have wrong representation
of my signs
such Ä ä Ü ü ß Ö ö.
I retrieve such signs
Ã" instead of Ä,
ä instead of ä
Ão instead of Ü
ü instead of ü
ÃY instead of ß
Ã- instead of Ö
ö instead of ö

Do anybody know where I make mistake or somebody know the solution?
It is very important to me, because I want to enlarge my application for
other languages.

Thanks a lot,
Nusret, Vienna

[Joerg Jooss]

"Nusret Bajric" wrote:

The file is encoded using UTF-8 (that's why you see two characters
instead of each original umlaut). Whatever application you're using to
view or edit the resulting file assumes that the file is encoded with
Windows 125x or ISO-8859-x encoding.

Cheers,
--
Joerg Jooss
joerg...@gmx.net