Character set on an Oracle DB problem

L

Lorenzo Brambilla

Hello all,
I have a problem retrieving data from an Oracle 8.1.7 DB.
The query execute correctly, but same characters of strings are not correct.
These characters are tipically deutch characters (ö et simila).
The nls_characterset, both for server and client is US7ASCII, and i can't
change it.
I tried the "Microsoft Data Provider for Oracle" and the "Oracle Data
Provider.NET" too, but I was unable to fix the problem.

Please HELP!!!

Lorenzo
 
P

Paul Clement

¤ Hello all,
¤ I have a problem retrieving data from an Oracle 8.1.7 DB.
¤ The query execute correctly, but same characters of strings are not correct.
¤ These characters are tipically deutch characters (ö et simila).
¤ The nls_characterset, both for server and client is US7ASCII, and i can't
¤ change it.
¤ I tried the "Microsoft Data Provider for Oracle" and the "Oracle Data
¤ Provider.NET" too, but I was unable to fix the problem.
¤

My understanding is that the US7ASCII character set doesn't support German language characters. The
bottom line is that you have to implement a character set that supports the languages for which you
are storing and retrieving data.


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top