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

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
huisjames
Forum Newbie
Posts: 5
Joined: Fri Nov 26, 2010 8:48 pm

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

Post 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
Post Reply