Home » Developer & Programmer » Data Integration » Need help on importing data from datasources with different characterset (Oracle 10g)
Need help on importing data from datasources with different characterset [message #412537] Thu, 09 July 2009 20:21
summoner
Messages: 44
Registered: March 2009
Member
Dear all,

We have 3 databases (A,B,C) in Windows server. A, B and C use different charactersets.
Now we need to import data from A, B to C. That is, 2 database (A,B) are data source and 1 database (C) is used as data warehouse. We find that we can display the text correctly in either A or B by updating the registry NLS_LANG, but not both.


I use the following command to check the characterset in DB
Quote:

SELECT parameter, value FROM v$nls_parameters WHERE parameter LIKE
'%CHARACTERSET';



The result is as follows:

"Datasource A"

NLS_CHARACTERSET AL32UTF8
NLS_NCHAR_CHARACTERSET UTF8



"Datasource B"

NLS_CHARACTERSET UTF8
NLS_NCHAR_CHARACTERSET UTF8



"Data warehouse C"

NLS_CHARACTERSET UTF8
NLS_NCHAR_CHARACTERSET AL16UTF16




We need a help to solve this problem so that both text can be displayed correctly.

Thanks for help
Previous Topic: Problem starting OWB after OS Switch
Next Topic: Deploy to multiple target schemas in the same database
Goto Forum:
  


Current Time: Thu Mar 28 11:29:05 CDT 2024