Page 1 of 1

CSV file won't take special characters - need to import into

Posted: Wed Dec 01, 2010 1:00 am
by huisjames
Hi,

I have rows and rows of data in Chinese characters in Excel .xlsx file. I need to import them into MySQL. I tried saving .xlsx as .csv but it the characters explode. Doesn't CSV support UTF-8? I tried changing the font to "Unicode" and that didn't help either.

Thanks