How To Set NLS_LANG parameter for export UTF8 to Import UTF8
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: How To Set NLS_LANG parameter for export UTF8 to Import UTF8

  1. #1
    Join Date
    Feb 2001
    Posts
    34

    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

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    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!


  3. #3
    Join Date
    Feb 2001
    Posts
    34
    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
  •  



Click Here to Expand Forum to Full Width