Home » Other » Client Tools » export chinise data in flat file (oracle 9i ,toad)
export chinise data in flat file [message #351854] Fri, 03 October 2008 08:27 Go to next message
tannad
Messages: 43
Registered: January 2008
Location: mumbai
Member
Hii..
I have one table which have chinise data
All data is correct .
I am exporting chinese data from Oracle table,I am facing problem
I export data through toad in flat file
and import it in XLS file using UTF character set .
After importing all character gets converted to ???? marks.
I cant see the data properly in the XLS file .
my guess data base is not exporting file as unicode and hence charactger gets converted

How I export data which I show correct data in chinise?

Report message to a moderator

Re: export chinise data in flat file [message #360909 is a reply to message #351854] Mon, 24 November 2008 05:53 Go to previous message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Try to set NLS_LANG to indicate to Oracle what character set it should use.

Regards.

Frank

Report message to a moderator

Previous Topic: Importing sysdate and Sequence into table from .csv using SQL Developer
Next Topic: sqlplus error
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 23 13:23:37 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.