Wrong data in 8i mview refreshed from 10g db with different characterset

From: Maureen English <sxmte_at_email.alaska.edu>
Date: Tue, 16 Sep 2008 16:44:19 -0800
Message-ID: <48D052E3.3030401@email.alaska.edu>

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

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Sep 16 2008 - 19:44:19 CDT