How to import chinese characters from excel into oracle and also extract chinese characters from oracle into excel?
A:
You would simply need to ensure that you have set Oracle to use a Unicode-compatible character encoding (I recommend UTF-8) and that no tool you are using to do the transfer is non-Unicode-safe.
Without knowing what you're using to do the transfer it's hard to give more specific information about where something is going wrong.
thomasrutter
2009-03-08 07:07:22
I think you mean UTF-16 as I'm sure chinese is like japanese and requires double byte characters to represent the full character set.
Dave Anderson
2009-03-08 14:14:21
Dave, both UTF-8 and UTF-16 are multi-byte character encodings supporting the full Unicode repertoire. Both should be suitable.
thomasrutter
2009-03-08 15:10:59
A:
Make sure the database is setup with the correct character set to store/house chinese characters properly. If the database can't store it then it pointless to imported it. If the database can support the asian character set then set the client character set to a compatible one. Once that is done the underline oci/odbc layer will handle the translation of one character set to the other as long as they are compatible.
MichaelN
2009-03-09 18:23:24
A:
Check the following.
- Database Character set (zhs16gbk)
- Set the local variable to NLS_LANG=SIMPLIFIED CHINESE.CHINA_UTF8
- Open the excel file save the file to unicode text
- open the text file save the file to ANSI format
- In the PLSQL developer, we have option called text importer. Using this tool we can import the data sucessfully
mukundhan
2010-07-27 03:06:55