Home » RDBMS Server » Server Utilities » Import/Export with UTF8
Import/Export with UTF8 [message #69870] Thu, 14 March 2002 22:12 Go to next message
christina
Messages: 9
Registered: November 2001
Junior Member
Hi, I have the source database UTF8 has chinese character, did an export on english unix machine,
but after import, the character not look like the same as before, is there is a way I can get it back from the dmp file.

Christina

Report message to a moderator

Re: Import/Export with UTF8 [message #69872 is a reply to message #69870] Fri, 15 March 2002 00:15 Go to previous messageGo to next message
Sanjay
Messages: 236
Registered: July 2000
Senior Member
you truncate the table and import the data again.
before import set
NLS_LANG= AMERICA.US7ASCII
export NLS_LANG

Report message to a moderator

Re: Import/Export with UTF8 [message #69875 is a reply to message #69870] Fri, 15 March 2002 05:50 Go to previous message
Grant
Messages: 578
Registered: January 2002
Senior Member
What was NLS_LANG set to on the export and what is it set to for the import? For any language other than US7ASCII (default) you are required to have the environment varibal set.

Report message to a moderator

Previous Topic: Export than recreate table with new column and than importport
Next Topic: how to move an entire schema
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Feb 02 18:12:48 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.