I am using Oracle 10g on Solaris. The database, I am told, is configured for UTF8. I have exported our development database and I need to import it into my test server which is also on solaris with the same oracle versions. The development app is fine but when I import the dump into the test environment, queries seem to bring back not only the english results but also ones with the double byte as well.
Here is the exp command I use
exp system@ITSMDEV file=/artmp/ardb01-utf8.dmp log=/artmp/ardb01-utf8.log owner=aradmin
and I import using
imp system@ITSMDEV file=/artmp/ardb01-utf8.dmp full=y
When I import, I get the following message that makes me think its not correct.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
Export done in AL32UTF8 character set and UTF8 NCHAR character set
server uses UTF8 character set (possible charset conversion)
So I think the UTF8 Vs UTF8 NCHAR is something that may be causing it to behave different.
Please can someone help and explain how I can exp using just UTF8 and not UTF8 NCHar, if thats the issue.
Im not that great at Oracle but I know a little. :)
Thanks for your time guys