Oracle, NLS and Unicode

Hi All,

We are using Oracle 7.1.4 and have been trying to import/export using ACCESS 2.0 and Oracle's latest ODBC driver. It all works fine UNTIL you move accented characters (i.e. codes > 127 in the ANSI/ISO 8859-1 code set). Moving from Oracle->Access they come out as if they were 7-bit values e.g. e-acute (233) becomes i (105). From Access->Oracle they appear as "?".

Anyone know anything about making this work?

This leads me on to another question, about NLS support in Oracle. How should we be creating the database to support Unicode? There doesn't seem to be an option that says "Unicode" for the character set part of the parameter.

Any clues? Does Oracle support Unicode? If not, anyone hear of support for this in a future release?

Cindy Burgio Received on Wed Jun 21 1995 - 00:00:00 CEST