OraFAQ Forum: Server Administration » Change the character set after database creation

Home » RDBMS Server » Server Administration » Change the character set after database creation (Oracle 10g , Windows 2003 Server - 64 bit)

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

Change the character set after database creation [message #313518]

Sun, 13 April 2008 06:33

Mahyaa
Messages: 3
Registered: April 2008

Junior Member

Hi all
I want to change the parameter "NLS_CHARACTERSET" from WE8MSWIN1252 to WE8ISO8859P1 .

The story is :
we want to migrate to 10g (from 9i) . In our old server NLS_CHARACTERSET parameter is WE8ISO8859P1 . My Application which is in Persian language used to work fine with this setting.But since the new changes it has few problems with some Persian characters (They change to "?" after posting). Sad

My clients NLS_Lang are set to AMERICAN_AMERICA.WE8ISO8859P1 and it is impossible to change all client's NLS_Lang.

how can i set my new server NLS_CHARACTERSET to be exactly the same as old one ?

thanks

[Updated on: Sun, 13 April 2008 06:49]

Report message to a moderator

Re: Change the character set after database creation [message #313519 is a reply to message #313518]

Sun, 13 April 2008 06:58

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

Senior Member
Account Moderator

Quote:

My Application which is in Persian language used to work fine with this setting.

No, it seems to work fine but it didn't. You just used wrong parameter settings.
WIN1252 is a superset of P1 so all what is in P1 is in WIN1252.
P1 does NOT support persian characters (nor WIN1252).

Regards
Michel

Report message to a moderator

Re: Change the character set after database creation [message #313522 is a reply to message #313519]

Sun, 13 April 2008 07:43

Mahyaa
Messages: 3
Registered: April 2008

Junior Member

Hi
Merci for your quick reply Michel Smile

Now my problem becomes double Sad

Do I need to reinstall Oracle Server to change the character set to something which supports Persian ?

thanks in advance .

Report message to a moderator

Re: Change the character set after database creation [message #313538 is a reply to message #313522]

Sun, 13 April 2008 08:51

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

Senior Member
Account Moderator

There can be so many reasons you have not valid characters in your database that it is impossible to answer.
Wrong client OS character set
Wrong client NLS_LANG
Wrong server OS character set
Wrong database character set (this is for sure)
Wrong server NLS_LANG
Same thing for application server if you have n-tiers application
...

In all cases, you have to recreate a database with the correct character set and fix the data that will without no doubt come wrong.

Regards
Michel

[Updated on: Sun, 13 April 2008 08:52]

Report message to a moderator

Previous Topic:	Add controlfile in ASM encounter error ORA-00214 ?
Next Topic:	Which query causing ORA-01555 error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 21:54:22 CST 2024