huisjames Posted December 1, 2010 Share Posted December 1, 2010 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 Link to comment https://forums.phpfreaks.com/topic/220331-csv-file-wont-take-special-characters-need-to-import-into-mysql/ Share on other sites More sharing options...
fenway Posted December 3, 2010 Share Posted December 3, 2010 CSV doesn't "support" anything -- it's just a bunch of commas. And if Excel doesn't produce UTF-8 output, then that's the root of your problems. Link to comment https://forums.phpfreaks.com/topic/220331-csv-file-wont-take-special-characters-need-to-import-into-mysql/#findComment-1142480 Share on other sites More sharing options...
huisjames Posted December 3, 2010 Author Share Posted December 3, 2010 Thanks Fenway. I decided to just enter them in SQL instead. Link to comment https://forums.phpfreaks.com/topic/220331-csv-file-wont-take-special-characters-need-to-import-into-mysql/#findComment-1142497 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.