How To Set NLS_LANG parameter for export UTF8 to Import UTF8
I have 2 databases running Oracle 8.1.5. This is on Solaris 8. Both have been set up to use the UTF 8 character set. Basically, we have a production machine A that exports to machine B. We have tables in both db that contain Spanish characters.
The problem. When we look at the tables on Machine A, we can see the special characters in the tables, such as accents at the like. When we look at the tables on Machine B, they are not there. Looking at the export log, I see this message:
import done in US7ASCII character set and UTF8 NCHAR character set
import server uses UTF8 character set (possible charset conversion)
When searching this site, I see references to change the NLS Charactor set to UTF8 when doing the import and export. Since the imp and exp commands are command line diven, how would I do it?
Set the NLS_LANG=your charcter set in the OS environment.
example: If you want to export the data in the UTF8 format then you set:
Then do the same for the import and things should work.
setenv NLS_LANG AMERICAN_AMERICA.UTF8
Life is a journey, not a destination!
Thanks! worked like a champ
Click Here to Expand Forum to Full Width