Home Forums SQL Server 2008 Working with Oracle Change of source databases(9i to 11g) 0xC02020F6 cannot convert between unicode and non-unicode string data types RE: Change of source databases(9i to 11g) 0xC02020F6 cannot convert between unicode and non-unicode string data types

  • Almost certain, AL32UTF8 is an unicode characterset. All char/varchar2/... columns can now store unicode characters. You can consider them nchar/nvarchar... by now.

    WE8ISO8859P1 is non-unicode.

    Because not all characters from AL32UTF8 can be represented in sqlserver varchar columns, the warning/error is thrown.

    NLS_CHARACTERSET can't be changed after the oracledatabase is created.