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.
Hi,
We want to convert the character set from WE8MSWIN1252 to AL32UTF8 in 11.2.0.3 database. Please provide us the doc ID to do it.
Thanks,
Vijay
2737606 wrote: Hi, We want to convert the character set from WE8MSWIN1252 to AL32UTF8 in 11.2.0.3 database. Please provide us the doc ID to do it. Thanks, Vijay
2737606 wrote:
you need to create new database using AL32UTF8 & populate the new DB with the old data
Is there any doc number for this?
http://docs.oracle.com/cd/B28359_01/server.111/b28298/ch11charsetmig.htm
You may need to look at this.
CSSCAN and CSALTER To Be Desupported after DB 11.2. (Doc ID 1418321.1)
The Database Migration Assistant for Unicode (DMU) Tool (Doc ID 1272374.1)
Sundar
Hi
You can refer following note
For CSSCAN :
Changing the NLS_CHARACTERSET to AL32UTF8 / UTF8 (Unicode) in 8i, 9i , 10g and 11g (Doc ID 260192.1)
DMU:
How to Migrate a WE8ISO8859P1 DB to AL32UTF8 using DMU 1.2 - an example (Doc ID 1546507.1)
I would start with official documentation here:
Database Globalization Support Guide https://docs.oracle.com/cd/E11882_01/server.112/e10729/toc.htm
especially Character Set Migration and Character Set Scanner Utilities parts
and MOS has many more docs in the topics. Here are some examples I collected for a similar task in the past
Changing the Database Character Set - a short overview. Note:225912.1 https://metalink.oracle.com/metalink/plsql/showdoc?db=NOT&id=225912.1
Changing the NLS_CHARACTERSET to AL32UTF8 / UTF8 (Unicode) Doc ID: 260192.1 https://metalink.oracle.com/metalink/plsql/showdoc?db=NOT&id=260192.1
AL32UTF8 / UTF8 (Unicode) Database Character Set Implications Doc ID: 788156.1 https://metalink.oracle.com/metalink/plsql/showdoc?db=NOT&id=788156.1
Installing and configuring Csscan in 10g and 11g (Database Character Set Scanner) Doc ID: 745809.1 https://metalink.oracle.com/metalink/plsql/showdoc?db=NOT&id=745809.1
Csscan output explained Doc ID: 444701.1 https://metalink.oracle.com/metalink/plsql/showdoc?db=NOT&id=444701.1
Examples and limits of BYTE and CHAR semantics usage (NLS_LENGTH_SEMANTICS) Doc ID: 144808.1 https://metalink.oracle.com/metalink/plsql/showdoc?db=NOT&id=144808.1
SCRIPT: Changing columns to CHAR length semantics Doc ID: 313175.1 https://metalink.oracle.com/metalink/plsql/showdoc?db=NOT&id=313175.1
...
I doubt that OP has been waiting 2 months for your advice.
Well I just copy-pasted links from my doc here for the archive search and scanner robots. Just like Sayed did.