-
How To Set NLS_LANG parameter for export UTF8 to Import UTF8
Greetings,
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?
Ken Hammer
-
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:
Code:
setenv NLS_LANG AMERICAN_AMERICA.UTF8
or
export NLS_LANG=AMERICAN_AMERICA.UTF8
Then do the same for the import and things should work.
Sam
Thanx
Sam
Life is a journey, not a destination!
-
Thanks! worked like a champ
Ken Hammer
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|