Re: How to make database to work with other languages!!!

Praven,

You have two options.

First option is to set UTF8 (or UTF16 for 9.2) as database characterset. This will enable you to store globalised text (any known character including Chineese, Japaneese and so on) in all character-type columns (VARCHAR2, CHAR, ...) Second option is to set another characterset (like WE8ISO8859P2) and use NCHAR and NVARCHAR for the columns that need to store globalised data.

The manual you need to check is Oracle9i Database Globalization Support Guide (a96529).

/Michael

Praveen wrote:
> Hi Tim,
>
> Thanks for the response. But as per the Oracle NLS documentation, The
> database should be in UTF8 format to support multiple langauages. In
> that case, how the tables will contain data of difference langauges
> like French, German etc.. and how about the procedures and functions?
>
> Thanks,
> Praveen
>
> "Tim Cuthbertson" <timNOcuthSPAM_at_bellsouth.net> wrote in message news:<qk5Na.12575$AK1.5446@fe04.atl2.webusenet.com>...
>

>>You need to check the Oracle Call Interface (OCI) in the Oracle
>>documentation. Specifically, the Application Developers Guide.
>>
>>Tim
>>
>>"Praveen" <spraveen2001_at_yahoo.com> wrote in message
>>news:98d8ec76.0307030431.6bb35109_at_posting.google.com...
>>
>>>Hi All,
>>>
>>>  We got a new requirement to develop an application using java and
>>>oracle as database and app should support multiple langauages. I have
>>>gone through the oracle8i NLS documentation, But still i hava a doubt
>>>like i should approach in terms of creating tables/indexes/procedures
>>>etc..Can anyone please help out in this?
>>>
>>>Thanks in Advance,
>>>Praveen

-- 
Hope this helps.

Michael Willer
Oracle & J2EE architect
Cyber Com Consulting a/s