| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
