Wrong data in 8i mview refreshed from 10g db with different characterset
Date: Tue, 16 Sep 2008 16:44:19 -0800
We have an 8i database (US7ASCII characterset) with materialized views being refreshed from a 10g database (was US7ASCII, just changed to WE8MSWIN1252).
Prior to converting the 10g database to WE8MSWIN1252, the data was displayed the same in both databases.
Langue et littérature français
resulted from a select statement in both databases when they were both US7ASCII. Now, the result is the same in the WE8MSWIN1252 database, but after I refreshed the materialized view, the result from the 8i database, which is still US7ASCII, is different:
Langue et litterature francais
The codepoints should have been the same in both databases, but for some reason, the refresh changed things.
The table in the 10g master (WE8MSWIN1252) database shows:
TEST> select dump(STVCIPC_DESC) from stvcipc where stvcipc_code='550100';
Typ=1 Len=30: 76,97,110,103,117,101,32,101,116,32,108,105,116,116,233,114,97,116,117,114,101,32,102,114,97,110,231,97,105,115
but the table in the 8i (US7ASCII) database shows different codepoints:
RPTT> select dump(STVCIPC_DESC) from stvcipc where stvcipc_code='550100';
Typ=1 Len=30: 76,97,110,103,117,101,32,101,116,32,108,105,116,116,101,114,97,116,117,114,101,32,102,114,97,110,99,97,105,115
If I select the codepoints from the 8i database, the characters show up correctly....
RPTT> select chr(101),chr(99),chr(233),chr(231) from dual;
C C C C
- - - -
e c é ç
Any ideas why the refresh of the materialized view wouldn't still contain the correct codepoints?