Wrong data in 8i mview refreshed from 10g db with different characterset
- From: Maureen English <sxmte@xxxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- 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.
For example:
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';
DUMP(STVCIPC_DESC)
------------------------------------------------------------------------------------------------------------------------------------
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';
DUMP(STVCIPC_DESC)
--------------------------------------------------------------------------------
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?
- Maureen
--
//www.freelists.org/webpage/oracle-l
Other related posts:
