Portuguese characters in Oracle Database

[Stuart Abramson]

We are consolidating Oracle Applications Instances from our Brazil datacenter into our US datacenter, where I'm currently assigned.

Apparently we don't need any special software options for HP-UX 11.0 and 11.11, such as are required for Kanji.
o.. Is that correct?

But the Oracle DBAs tell me that they will have to set some character set options:
o..We currently run the default US character set in Oracle which is called:
..-..what?
o..They are going to install the Brazil database with:
..-..WE8ISO59P1 ?

Can someone tell me the correct "names" for these character set options?

[Jean-Luc Oudart]

Hi

I believe for Portuguese yuo will choose character set WE8ISO59P15

cf. http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14225/ch2charset.htm#NLSPG002

Regards
Jean-Luc

[Jean-Luc Oudart]

Hi again,

the default character set is US7ASCII (7 bits per character).

Also, the client can be different (uses NLS_LANG variable) :
Setting the NLS_LANG parameter properly is essential to proper data conversion. The character set that is specified by the NLS_LANG parameter should reflect the setting for the client operating system. Setting NLS_LANG correctly enables proper conversion from the client operating system character encoding to the database character set. When these settings are the same, Oracle assumes that the data being sent or received is encoded in the same character set as the database character set, so character set validation or conversion may not be performed. This can lead to corrupt data if conversions are necessary

extract from Globalization support guide - Oracle

Regards
Jean-Luc

[Yogeeraj_1]

hi,

UTF8 is a character set that permits you to store multi-byte data.

also, have a look at the Globalisation Guide found at:
http://otn.oracle.com/pls/db92/db92.docindex?remark=homepage#index-GLO

and metalink note: 62421.1
Subject: Which Character Set Supports Which Language

Also note that the client needs to use a character set setting that is appropriate for the data they are inserting.

hope this helps too!

kind regards
yogeeraj

[Eric Antunes]

Hi Stuart,

Oracle Applications lets you have 2 languages and 2 different environements. In your case I beleave it would be:

- Brazilian Portuguese (Base Language)
- American English

So, you'll have 2 different NLS_LANG in the 2 different environement files (.env and _br.env, usualy located at $APPL_TOP):

Acording to _.WE8ISO8859P1:

NLS_LANG="PORTUGUESE_BRAZIL.WE8ISO8859P1"
export NLS_LANG

NLS_LANG="AMERICAN_AMERICA.WE8ISO8859P1"
export NLS_LANG

Check this note for more about it: http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=333785.1

Best Regards,

Eric Antunes

[Eric Antunes]

$APPL_TOP/.env should have:

NLS_LANG="AMERICAN_AMERICA.WE8ISO8859P1"
export NLS_LANG

And $APPL_TOP/_ptb.env (PTB is the Brazilian Portuguese language code) should have:

NLS_LANG="PORTUGUESE_BRAZIL.WE8ISO8859P1"
export NLS_LANG

PS: $APPL_TOP points to something like /disc/app/applmgr/11 and the application owner user usually is applmgr.

Best Regards,

Eric Antunes

[Stuart Abramson]

thanks all. Our DBAs are looking into the issue. I was just curious...

Apparently here in the US we run some Instances UTF8 and some WE81ISO8859P1 (according to some scheme that they [DBAs] have).

They are getting IDs on the Brazil Oracle Instances to look at them...