Special characters change after import/export
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 1 of 1

Thread: Special characters change after import/export

  1. #1
    Join Date
    May 2003

    Question Special characters change after import/export


    I have a problem with an export/import I'm doing. I have an 8.1.5 d/b on Solaris with char set WE8ISO8859P1. NLS_LANGUAGE is AMERICAN and NLS_TERRITORY = AMERICA. I have tables on this d/b containing foreign characters, eg: acute/grave accents and umlauts.

    When I export these tables and import them into an 8.1.7 database (same platform and NLS database parameters), the special characters have been translated, e.g.: e-acute becomes e.

    NLS_LANG has been set to AMERICAN_AMERICA.WE8ISO8859P1 in both environments.

    Any ideas?

    Last edited by Stampy; 12-16-2003 at 10:06 AM.

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