The thing you need to change is: don't use nchar in Oracle 8. Oracle 8 doesn't support the UTF-16 encoding. Oracle 9 and SQL Server provide 16-bit Unicode using the alternate character datatypes. In Oracle 8 the nchar/nvarchar types are used for an alternate character encoding, but this encoding can only be a Unicode encoding (UTF8 or AL24UTFFSS) if the main character set of the database is already UTF8 (or AL24UTFFSS), which means you don't need nchar types and you still have to deal with the byte/char count differences.
For Oracle 8/8i you will probably want to configure your database to use the UTF8 character set. This will affect how your DDL is written and mean some minor tweaks to your SQL statements (you'll need to remove the "N" qualifiers on your strings). I have a whitepaper from the Unicode Conference #19 at http://www.inter-locale.com/ICU19.pdf that may help you a little.
Addison P. Phillips
Globalization Architect / Manager, Globalization Engineering
webMethods, Inc. 432 Lakeside Drive, Sunnyvale, CA
+1 408.962.5487 (phone) +1 408.210.3659 (mobile)
Internationalization is an architecture. It is not a feature.
> -----Original Message-----
> From: email@example.com
> [mailto:firstname.lastname@example.org]On Behalf Of P.S.L.Sarada Devi
> Sent: 2002年5月10日 4:12
> To: email@example.com
> Subject: regarding unicode support in Oracle8i
> Dear Sir/Madam,
> We are trying to insert unicode chars(Hindi and Telugu) into a table in of
> data type 'nchar' in Oracle.
> We are able to do same thing in sqlserver.
> How it can be done in Oracle8i?
> Is there anything to be configured in Oracle server before doing that?
> Please mail me asap.
> Thank you all.
This archive was generated by hypermail 2.1.2 : Fri May 10 2002 - 12:45:36 EDT