Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Precautions i need to take when changing the Character set

WilhelmAug 5 2007 — edited Aug 5 2007
Hi,
ORACLE VERSION: 10G Release 1 (10.1.0.3.0)

I am going to change my database's characterset from AL32UTF8 to WE8MSWIN1252 character set and AL16UTF16 NCHAR character set. So i have few questions for you.

1. What is the difference between Character Set and National Character set? Do i have to set both?

2. What are precautions that i need to take while changing the characterset?

3. What are JOB_QUEUE_PROCESSES and AQ_TM_PROCESSES parameters in Plain English? Why do i have to set these parameters to 0 as mentioned in this post below.
454102

Comments

JustinCave
1) The database character set controls (and specifies) the character set of CHAR & VARCHAR2 columns. The national character set controls the character set of NCHAR & NVARCHAR2 columns.

2) Please make sure that you read the section of the Globalization manual that discusses character set migration. In particular, going from UTF-8 to Windows-1252 is going to require a bit more work since the latter is a subset (and not a strict binary subset) of the former.

Justin
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 2 2007
Added on Aug 5 2007
#general-database-discussions
1 comment
328 views