OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Characterset Change (Windows 2003)

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

Characterset Change [message #433101]

Mon, 30 November 2009 01:31

samit_gandhi
Messages: 226
Registered: July 2005
Location: Hong Kong

Senior Member

Hi,

I want to use the character of simplified chinese in my oracle database. I search for all and i found that i need to change the character set of the database. Can anybody give me steps for changing the character set? and which character set should be suitable to me?

My current character sets are as below :

NLS_CHARACTERSET=WE8MSWIN1252
NLS_NCHAR_CHARACTERSET=AL16UTF16

Thanks in advance

Samit Gandhi

Report message to a moderator

Re: Characterset Change [message #433102 is a reply to message #433101]

Mon, 30 November 2009 01:39

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

You have to create a new database with the new character set, export the old database and reimport in the new one using each the appropriate character set in NLS_LANG to minimize the conversions.

Regards
Michel

Report message to a moderator

Re: Characterset Change [message #433105 is a reply to message #433102]

Mon, 30 November 2009 01:49

samit_gandhi
Messages: 226
Registered: July 2005
Location: Hong Kong

Senior Member

what is the appropriate characterset for the simplified chinese and chinese prc

samit gandhi

Report message to a moderator

Re: Characterset Change [message #433106 is a reply to message #433105]

Mon, 30 November 2009 02:13

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

I don't know, read Database Globalization Support Guide, Chapter 2 Choosing a Character Set.

And use the following to find the more appropriate one:

select value from V$NLS_VALID_VALUES where parameter='CHARACTERSET' order by 1;

Regards
Michel

Report message to a moderator

Previous Topic:	Find dbms_scheduler Jobs Running
Next Topic:	PMON trace is increasing fastly

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 01 00:42:44 CDT 2024