Re: Japanese characters support in Oracle Intermedia

When creating the database, you will be asked to specify two character sets. If I remember correctly, the first one is called the database character set and the second is called the national character set.

The database set defines the types of characters stored in CHAR, VARCHAR, CLOB datatypes. Usually, this can be set to an appropriate 8 bit character set, depending on what type of host your server runs on.

The second character set defines the type of characters held in special data types NCHAR, NVARCHAR, NCLOB and so on. Set this to one of the multilingual character sets like UTF8 to store Japanese.

I think it's possible to choose country specific character sets (e.g. Japanese only) which might be more efficient for your application but I think I remember reading somewhere that Oracle is phasing out support for this and that only the multilingual character sets will be supported in future.

One point to bear in mind is that the indexing facilities offered by InterMedia do not support the NCLOB data type. If you want to use InterMedia to index large blocks of text, you might need to set the database character set to multilingual and use CLOB fields.

Full details are in the Oracle Database Globalization Support Guide.

"S V" <sarvodaya2001_at_yahoo.com> wrote in message news:691bd474.0301201443.a3714d4_at_posting.google.com...
> We need to localize our software for our client in Japan. It will have
> its seperate code base so we don't have to worry about suporting
> multiple languages on the same machine.
>
> I have all the VB and ASP covered, but I am not sure what I need to do
> for Oracle. We use Intermedia with Oracle and someone told me that it
> takes just a few minutes to setup Intermedia to support Japanese or
> any other language. Can anyone point me in the right direction?
>
> All I want is to be able to store and retrieve Japanese characters
> from Oracle and Intermedia.
>
> Many thanks,
> S Vir
Received on Mon Jan 20 2003 - 17:40:24 CST