Home » RDBMS Server » Server Administration » Change the character set after database creation (Oracle 10g , Windows 2003 Server - 64 bit)
icon5.gif  Change the character set after database creation [message #313518] Sun, 13 April 2008 06:33 Go to next message
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 Go to previous messageGo to next message
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
Re: Change the character set after database creation [message #313522 is a reply to message #313519] Sun, 13 April 2008 07:43 Go to previous messageGo to next message
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 .


Re: Change the character set after database creation [message #313538 is a reply to message #313522] Sun, 13 April 2008 08:51 Go to previous message
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:
  


Current Time: Sat Dec 07 01:47:31 CST 2024