doubledee Posted August 12, 2011 Share Posted August 12, 2011 I am trying to paste an article that was formerly in NetBeans (i.e. single .php file) into a field in a record in phpMyAdmin. I keep getting this error when I paste my article into phpMyAdmin... Warning: #1366 Incorrect string value: '\xE2\x96\xAA Ch...' for column 'body' at row 1 How can I *easily* fix this?? Debbie Link to comment https://forums.phpfreaks.com/topic/244570-problem-inserting-article-with-single-quotes/ Share on other sites More sharing options...
fenway Posted August 12, 2011 Share Posted August 12, 2011 Then your code page is wrong -- you're not inserting latin characters. Link to comment https://forums.phpfreaks.com/topic/244570-problem-inserting-article-with-single-quotes/#findComment-1256472 Share on other sites More sharing options...
doubledee Posted August 12, 2011 Author Share Posted August 12, 2011 Then your code page is wrong -- you're not inserting latin characters. Can you be a little more specific?! (Not following you.) My page worked as a .php file. One would think that pasting working HTML/Text from a .php file into a field in phpMyAdmin would yield the same results?! Debbie Link to comment https://forums.phpfreaks.com/topic/244570-problem-inserting-article-with-single-quotes/#findComment-1256526 Share on other sites More sharing options...
doubledee Posted August 12, 2011 Author Share Posted August 12, 2011 According to NetBeans, my encoding is UTF-8... Debbie Link to comment https://forums.phpfreaks.com/topic/244570-problem-inserting-article-with-single-quotes/#findComment-1256563 Share on other sites More sharing options...
fenway Posted August 12, 2011 Share Posted August 12, 2011 Then your field has \xXX characters in it -- which you need to replace with the corresponding UTF-8 characters. Link to comment https://forums.phpfreaks.com/topic/244570-problem-inserting-article-with-single-quotes/#findComment-1256580 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.