Forum Stats

  • 3,782,753 Users
  • 2,254,686 Discussions
  • 7,880,153 Comments

Discussions

Character set conversion doubt

User_YCF4A
User_YCF4A Member Posts: 2 Employee

Hi,

We are planning to migrate the database from US7ASCI to AL32UTF8 character set .

We have found AL32UTF8 is a binary superset of US7ASCI

AS per the doc

https://docs.oracle.com/database/121/NLSPG/ch2charset.htm#NLSPG1037

"By definition, character set A is a binary superset of character set B if A supports all characters that B supports and all these characters  have the same binary representation in A and B. Character set B is a binary subset of character set A if A is a binary superset of B. When character set A is a binary superset of character set B, any text value encoded in B is at the same time valid in A without need for character set  conversion."

  In this scenario do we need to do a character set conversion using DMU or CSSCAN while doing a database migration. Can you please confirm


Regards

Baiju.R

Answers