You can store the information in UTF8, which is the format that Oracle uses
for Unicode. By setting this as the db charset any of the text datatypes
such as char and varchar2 will be stored using UTF. If you are using Java,
JDBC will do the conversion each way automatically.
Since UTF8 is a superset of ASCII and other character sets, if you have
already have a database created and populated, you can still easily simply
change this parameter and restart the database. (But note that you can't do
the reverse...)
You also need to know that the width of columns refers to the maximum number
of UTF8 bytes, not abstract characters, stored. Non-ASCII characters may
take up more space--up to three bytes, so the width of your columns will
need to increase correspondingly, especially if you know that it will store
Chinese.
----- Original Message -----
From: "Charlie Wu" <cwu@brocade.com>
To: <unicode@unicode.org>
Sent: Monday, May 07, 2001 2:56 PM
Subject: how to store unicode in oracle?
> Hi there:
>
> I am trying to store some information in Chinese to an oracle db (8.1.6)
who
> NLS_PARAMETERS are as pasted below.. what kind of datatype should I use to
> store unicode? Is there a way I can store this as ascii/varchar2 and then
> somehow when my java application retrieves the data display it as Unicode
or
> GB chinese again?
>
> Thanks!
>
> Charlie
>
>
> <<Charlie Wu.vcf>>
>
This archive was generated by hypermail 2.1.2 : Fri Jul 06 2001 - 00:18:17 EDT