I have two DB.
(A) setting is "NLS_LANGUAGE=TRADITIONAL CHINESE_HONG KONG.ZHT16MSWIN950"
(B) is "NLS_LANGUAGE=AMERICAN_AMERICA.WE8ISO8859P1"
Now use a Oracle Client(C) to connect the two DB.
if I set C "NLS_LANGUAGE=TRADITIONAL CHINESE_HONG KONG.ZHT16MSWIN950", it can access A db correctly but can not get correct data from B db.
if I set C "NLS_LANGUAGE=AMERICAN_AMERICA.WE8ISO8859P1", it can access B db correctly but can not get correct data from A db.
I am using OO4O in VB to access the two db data.
Anybody know how to access the two db with difference language set.