Home » RDBMS Server » Server Administration » Characterset Change (Windows 2003)
Characterset Change [message #433101] Mon, 30 November 2009 01:31 Go to next message
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
Re: Characterset Change [message #433102 is a reply to message #433101] Mon, 30 November 2009 01:39 Go to previous messageGo to next message
Michel Cadot
Messages: 63802
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
Re: Characterset Change [message #433105 is a reply to message #433102] Mon, 30 November 2009 01:49 Go to previous messageGo to next message
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
Re: Characterset Change [message #433106 is a reply to message #433105] Mon, 30 November 2009 02:13 Go to previous message
Michel Cadot
Messages: 63802
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
Previous Topic: Find dbms_scheduler Jobs Running
Next Topic: PMON trace is increasing fastly
Goto Forum:
  


Current Time: Mon Sep 26 06:03:58 CDT 2016

Total time taken to generate the page: 0.10012 seconds