Character set on an Oracle DB problem

  • Thread starter Thread starter Lorenzo Brambilla
  • Start date Start date
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
 
¤ 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)
 
Back
Top