We have an oracle9i DB, the default character set is WE8PC850 and the NLS character set is UTF8, some of the tables store both English, Chinese and Portuguese.
I use Access2000 to import or create table link from the Oracle9i DB, through ODBC, the chinese cannot be displayed but the Portuguese appeared normally in Access2000, but if i export the table to Excel2000 through Access2000(office link), the Chinese words displayed normally but the Portuguese characters cannot appeared.
I have tried it in both WinXP English/Chinese edition.
How to solve the above problem??