tgeorge06 Posted October 19, 2010 Share Posted October 19, 2010 I'm trying to import a .xlsx file into mysql database with the newest Navicat. It works, but there is a problem. My longtext field cuts off mid sentence on a few of my rows and replaces everything else with 3 question marks. I've set what i thought was the proper charset...UTF8, not sure where i'm going wrong. Link to comment https://forums.phpfreaks.com/topic/216280-excel-to-mysql-import-issue/ Share on other sites More sharing options...
roopurt18 Posted October 19, 2010 Share Posted October 19, 2010 Not all byte sequences are valid in UTF-8. A common convention by programs reading supposedly UTF-8 data is to convert such sequences to question marks. Perhaps that is occurring in your case. Link to comment https://forums.phpfreaks.com/topic/216280-excel-to-mysql-import-issue/#findComment-1124014 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.