Discussion :

[fouad77fr]

Bonjour à tous,

j'ai une base de données Oracle 9i sous le charset WE8ISO8859P1. Est-ce que je peux changer le charset au UTF-8 ? et comment ?

merci d'avance.

[pifor]

La solution recommandée est l'export/import en raison des colonnes CLOB dans le dictionnaire:

Another restriction of the ALTER DATABASE CHARACTER SET statement is that it can be used only when the character set migration is between two single-byte character sets or between two multibyte character sets. If the planned character set migration is from a single-byte character set to a multibyte character set, then use the Export and Import utilities.

This restriction on using the ALTER DATABASE CHARACTER SET statement arises because of CLOB data. In Oracle9i, some internal fields in the data dictionary are stored in CLOB columns. Customers may also store data in CLOB fields. When the database character set is multibyte, CLOB data in Oracle9i is stored as UCS-2 data (two-byte, fixed-width Unicode). When the database character set is single-byte, CLOB data is stored using the database character set. Because the ALTER DATABASE CHARACTER SET statement does not convert data, CLOB columns remain in the original database character set encoding when the database character set is migrated from single-byte to multibyte. This introduces data inconsistency in the CLOB columns.

Voir ici.

[fouad77fr]

Merci bcp