How to create delimited file (comma or tab) for gb2312 encoding

[Aiyo]

Hello,
I would like your advises on how I can create GB2312 encoded, comma or tab delimited file. I have some excel files that are written in simplied chinese, need to find a way to to import these files to mysql in order to display the data in GB2312 encoding website.

I tried the conversion for "UTF8" sucessfully but don't know how (which tool to use) for GB2312.

For "UTF8" encoding:
- In Excel, saved the xls files as "Unicode Text" type.
- In Notepad, opened the unicode txt files and save again as "UTF8" encoding
- Run "Load Data" command from mysql command line to import the "UTF8" encoding files
- I am able to view the data in Simplied Chinese from phpMyAdmin if I set my browser to "UTF8" encoding

Since neither Excel nor Notepad allows me to save file to "GB2312" encoding, I have no clues how to import the data file to mysql in order to display in GB2312 encoding website.

Any suggestions?

[guoqi]

How about you ask or hire some one to write a piece of code for you? This should be < 2 hour programming work to write this convertor.

[bill]

David_M suggested a very handy tool: BabelPad [webmasterworld.com] that handles simple conversions quite well. I'm not sure how well it would work with a CSV file, but you could give it a try.