OraFAQ Forum: Server Administration » how to change character set in oracle 11g r2

Home » RDBMS Server » Server Administration » how to change character set in oracle 11g r2 (11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production , RHEL 6.5)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to change character set in oracle 11g r2 [message #638866]

Tue, 23 June 2015 23:19

someswar1
Messages: 53
Registered: January 2008

Member

From My OS RHEL 6.5 Charaterset set as

set|grep NLS
NLS_DATE_FORMAT='DD.MM.YYYY HH24:MI:SS'
NLS_LANG=AMERICAN_AMERICA.AL32UTF8
ORA_NLS10=/opt/oracle/product/11.2.0.3/nls/data

And Oracle DB data base has at the moment:

NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET AL32UTF8

I need to update DB and os with this characterset AMERICAN_AMERICA.WE8ISO8859P15 .

Please help me how would I doing this without drop and reinstall the DB.

Regards
Someswar

Report message to a moderator

Re: how to change character set in oracle 11g r2 [message #638867 is a reply to message #638866]

Tue, 23 June 2015 23:31

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Welcome to this forum.

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and read http://www.orafaq.com/forum/t/174502/

The only approved way to establish a characterset for any Oracle database is to specify it when the database is initially created.

Report message to a moderator

Re: how to change character set in oracle 11g r2 [message #638869 is a reply to message #638867]

Tue, 23 June 2015 23:48

someswar1
Messages: 53
Registered: January 2008

Member

Hello,

So there is no other way to change characterset if DB has been created?

Regards
Someswar

Report message to a moderator

Re: how to change character set in oracle 11g r2 [message #638870 is a reply to message #638869]

Tue, 23 June 2015 23:51

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

You can modify the DB content, but results may be indeterminate.

Report message to a moderator

Re: how to change character set in oracle 11g r2 [message #638871 is a reply to message #638866]

Wed, 24 June 2015 00:48

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Create a new db, export the old one, import into the new one.
What is the reason you NEED to change your character set from AL32UTF8 (which supports all characters) to WE8ISO8859P15 (which only supports western European characters)?

Report message to a moderator

Re: how to change character set in oracle 11g r2 [message #638875 is a reply to message #638871]

Wed, 24 June 2015 01:37

someswar1
Messages: 53
Registered: January 2008

Member

Hello,

Actually my application supports only WE8ISO8859P15. Thatswhy I wanted to convert it .
At present these is the present Value

NAME VALUE
----------
LANGUAGE AMERICAN
TERRITORY AMERICA
CHARACTER SET AL32UTF8

If its not possible then please suggest me that if the database seed is configured with the AL32UTF8 character set, update the NLS_LANG with the following pattern (where the 'LANGUAGE', 'TERRITORY' and 'CHARACTER_SET' are those from the above result.

How would I update this?

Regards
Someswar

Report message to a moderator

Re: how to change character set in oracle 11g r2 [message #638876 is a reply to message #638875]

Wed, 24 June 2015 01:41

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

Actually my application supports only WE8ISO8859P15.

Client and database character sets are completely independent, the only thngs to check are 1) the database character set contains at least all the characters the application/client need and 2) the client NLS_LANG parameter is correctly set to its own character set.
So just set your client character set to AMERICAN_AMERICA.WE8ISO8859P15 if this is the value it needs.

Report message to a moderator

Previous Topic:	SGA Size modification
Next Topic:	Oracle 10g installation Problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 04 01:30:17 CDT 2025