RDBPROD: How to convert a CHAR column to an UTF8 CHAR column (Doc ID 1253975.1)

Last updated on FEBRUARY 21, 2024

Applies to:

Goal

In an existing Rdb database, defined with the default character set DEC-MCS, there is a new requirement to store Chinese characters, using the UTF8 character set, in some columns. How can the table and the column be altered to make this possible while retaining the original data in the table?

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.