How to display both We8dec and ZHS16GBK two sets of characters!

How to display both We8dec and ZHS16GBK two sets of characters. 2011-10-10 14:23:59 http://blog.itpub.net/25702/viewspace-708889 two sets of databases. BWP database: Character set to We8dec
Bobo database: Character set is ZHS16GBK.
You need to display table data for two databases at the same time on the client.
Simple set Nls_lang, can only have one result correct at the same time, need the following operation, in order to simultaneously
Show.

My test action is as follows: 1, in the BWP database will need to query the text section to do the following transformation: create view test_char as select utl_raw.cast_to_ Raw (TXTMD)  txtmd   from  "/bi0/tcustomer"   where rownum<2; 2, create a connection to the BWP database in the Bobo database.   Create database link testlink connect to bwprd_bouser identified  by bo0927 using  ' BWP '; 3. Create the following view in the Bobo database: Create view test_char as select utl_raw.cast_to_varchar2 (TXTMD)   TXTMD from  Test_char@testlink; 4, in any client settings Nls_lang as follows: Nls_lang=simplified Chinese_china. ZHS16GBK 5, landing Bobo database, do the following query, the results are displayed in Chinese characters: system@bobo> select * from test_char; TXTMD------------------------------------------------------------------------Beijing Micro-Metal Materials Co., Ltd.   System@bobo > select RNAME from  vdzy where rownum<2; Rname----------------------------------------Product Quantity Inquiry