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