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.
Last edited by Stampy; 12-16-2003 at 10:06 AM.
Click Here to Expand Forum to Full Width