Re: ODBC access to Sun Oracle server

Hi,
I've done this for an AIX box before, but moved jobs since, and left the "Tech note" behind.

****TAKE A FULL BACKUP BEFORE TRYING THIS KIDS ********** IF THIS GOES WRONG, YOU DATABASE WON'T OPEN (ever)!

The charicter set is held in sys.props$. If you look at this, the NLS_CHARACTERSET is probably US7ASCII (default). All you need to do is update this to the 8-bit char set of your choice (new set MUST be a superset of the origional). Startup the database in restricted mode, update the table, restart the database. If it doesn't come back up, get the tapes out! ;-) I went to WE8ISO9002 (I think that's it, but look it up in the docs).

Oracle support have a couple of good articles on this (if you've got access to support....)

Good luck,

From Will

"Alexander W. Meyer" wrote:

> I have Sun with Oracle Server 8.0.4 and WinNT with ODBC drivers (MS odbc
> driver for Oracle and Oracle odbc driver). And when I send SQL request
> through any ODBC driver to Oracle Server then I receive 7 bit instead of 8
> bit and all national language symbols are corrupted. I can't find any
> options in Oracle client configuration manager (this manager installed on
> WinNT) and in ODBC drivers.
> Does anyone know how can I solve this problem?

--

ISS UNIX support
The University Of Leeds.
0113 233 5670 Received on Wed Sep 15 1999 - 12:43:35 CDT