ResolvingCharactersetissuesduringdatamigration..pdf

Version 1

    Character set issues encountered in Oracle RDBMS during data migration


    1. Main issues one database has AL32UTF8 and the other has WE8MSWIN1252
    2. nchar vs char oracle
    3. NVARCHAR2 vs VARCHAR2
    4. AL16UTF16 vs UTF8
    5. character set considerations oracle 11g

    If I store the letter 'a' in a NVARCHAR2 column, Oarcle would allocate 2 bytes of storage if the NLS_NCHAR_CHARACTERSET is AL16UTF16
    To find the character sets from two systems, use the query below. Run it on both systems and note the results.

    • select * from v$nls_parameters where parameter='NLS_CHARACTERSET';
    • AL32UTF8 vs WE8ISO8859P1

    https://community.oracle.com/thread/2135623?start=0&tstart=0