I am trying to save it as a csv and them import them to oracle thru sql loader but the chinese character get transformed into ?????? in the csv file as a result in oracle they also look the same as ?????.If the characters are converted before being imported you couldn't get them back after the import. They are lost.
I also tried saving them into unicode text and separated by "pipe delimiter " but when it comes to oracle the chinese characters turn into gebarish.It's recommended to use AL32UTF8 Character Set on the Target Database. You may check it with the following query.
About conversion problem, the followin Notes from MOS give good advices:
select * from v$nls_parameters where parameter like 'NLS_CHARACTERSET';
The Chapter C.3) Configuring your Windows client to be an UTF-8 (Unicode) client. of the Note *788156.1* may be useful.
Character Sets & Conversion - Frequently Asked Questions [ID 227330.1] AL32UTF8 / UTF8 (Unicode) Database Character Set Implications [ID 788156.1]