Home » SQL & PL/SQL » 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?
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: 4502
Registered: April 1998
Senior Member
Try to set NLS_LANG to indicate to Oracle what character set it should use.

Regards.

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


Current Time: Wed Dec 07 20:08:06 CST 2016

Total time taken to generate the page: 0.10736 seconds