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 Quote 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. Quote 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. Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.