Both Oracle OLEDB and ODBC drivers does not support NCHAR and NVARCHAR2 data
type in server for Oracle8i. But the latest ODBC driver starting from 220.127.116.11
will support Unicode datatype for ODBC driver as wchar. You can download the
latest ODBC drive driver from OTN:
Just for your info, both OLEDB and ODBC drivers will support NCHAR/NVARCHAR2
data type as reliable Unicode data type in 9i release.
"Michael (michka) Kaplan" wrote:
> Why not use the OLE DB provider instead? It would do a much better job, from
> what I have been told!
> a new book on internationalization in VB at
> ----- Original Message -----
> From: "Paul Deuter" <Paul.Deuter@plumtree.com>
> To: "Unicode List" <email@example.com>
> Sent: Wednesday, November 29, 2000 11:44 AM
> Subject: Unicode and Oracle and ODBC
> > We have been having difficulty using Unicode with Oracle through ODBC.
> > Apparently the most current ODBC drivers were written to the Oracle 7 API
> > which
> > does not have support for NCHAR and NVARCHAR2. We have tried to find an
> > updated ODBC driver from Microsoft, Oracle, and others but none seems to
> > exist.
> > This seems fairly incredible to me since Oracle is such a popular database
> > and
> > has such a presence around the world.
> > Does anyone know how to use Unicode with Oracle using ADO through ODBC?
> > Thanks,
> > Paul
> > Paul Deuter
> > Internationalization Manager
> > firstname.lastname@example.org
This archive was generated by hypermail 2.1.2 : Tue Jul 10 2001 - 17:21:15 EDT