Title: Error Incorrect string value Last modified: August 21, 2016 --- # Error Incorrect string value * [Pedro_md7](https://wordpress.org/support/users/pedro_md7/) * (@pedro_md7) * [12 years ago](https://wordpress.org/support/topic/error-incorrect-string-value/) * Hi, suddenly my blog ([blog.losgalayos.net](http://www.blog.losgalayos.net)) not working correctly if I disable the plugin Rotating Tweets. Displays the following error: * _[ Moderator note: please wrap code in [backticks or use the code button](http://codex.wordpress.org/Forum_Welcome#Posting_Code). Do not use blockquote. ]_ * ``` Error Incorrect string value: '\xF0\x9F\x98\x9C T...' for column 'option_value' at row 1 de la base de datos de WordPress para la consulta INSERT INTO wp_options (option_name, option_value, autoload) VALUES ('rotatingtweets-cache', 'a:1:{s:12:\"losgalayos11\";a:2:{s:4:\"json\";a:35:{i:0;a:6:{s:4:\"text\";s:140:\"Agradecimientos eternos a nuestros amigos de Madrid por la visita de ayer. Pudimos disfrutar de sus bailes #SanIsidro http://t.co/PqwIBVaK9i\";s:4:\"user\";a:5:{s:11:\"screen_name\";s:10:\"LosGalayos\";s:2:\"id\";i:142731175;s:4:\"name\";s:16:\"Rte. Los Galayos\";s:23:\"profile_image_url_https\";s:75:\"https://pbs.twimg.com/profile_images/458916425042653184/x0ERI0V__normal.png\";s:17:\"profile_image_url\";s:74:\"http://pbs.twimg.com/profile_images/458916425042653184/x0ERI0V__normal.png\";}s:8:\"entities\";a:3:{s:4:\"urls\";a:0:{}s:5:\"media\";a:1:{i:0;a:10:{s:2:\"id\";d:4.6720221020437709E+17;s:6:\"id_str\";s:18:\"467202210204377090\";s:7:\"indices\";a:2: ``` * Now it does not show the error because I have disabled the plugin. * Thank you, greetings. * [https://wordpress.org/plugins/rotatingtweets/](https://wordpress.org/plugins/rotatingtweets/) Viewing 8 replies - 1 through 8 (of 8 total) * Plugin Author [Martin Tod](https://wordpress.org/support/users/mpntod/) * (@mpntod) * [12 years ago](https://wordpress.org/support/topic/error-incorrect-string-value/#post-4921645) * Looks like the Tweet string is too big to save. * Do you have the latest version installed? It dramatically reduces the file size. * What are the settings in your shortcode? * Plugin Author [Martin Tod](https://wordpress.org/support/users/mpntod/) * (@mpntod) * [12 years ago](https://wordpress.org/support/topic/error-incorrect-string-value/#post-4921683) * I’ve looked into this a bit further. * I think the problem appears to be that your database is not UTF-8 encoded – when WordPress expects it to be. If you have an accent or something similar in your tweet stream, this will break things. * There’s more on this at [http://stackoverflow.com/questions/1168036/how-to-fix-incorrect-string-value-errors](http://stackoverflow.com/questions/1168036/how-to-fix-incorrect-string-value-errors) * Plugin Author [Martin Tod](https://wordpress.org/support/users/mpntod/) * (@mpntod) * [12 years ago](https://wordpress.org/support/topic/error-incorrect-string-value/#post-4921720) * PS: Or rather the `wp_options` table in your database may not be UTF-8 encoded… * Plugin Author [Martin Tod](https://wordpress.org/support/users/mpntod/) * (@mpntod) * [12 years ago](https://wordpress.org/support/topic/error-incorrect-string-value/#post-4921734) * It’s the [same problem as you had with the WordPress Related Posts plug-in](http://wordpress.org/support/topic/issue-with-related-posts-plugin?replies=15)– and the solution might be similar – although the Rotating Tweets code for this is unlikely to be a change to a single line unfortunately! * As was mentioned in the RP plug-in discussion, there’s almost certainly a problem with your server/MySQL/PHP settings somewhere – but I will see if I can come up with a solution. * Plugin Author [Martin Tod](https://wordpress.org/support/users/mpntod/) * (@mpntod) * [12 years ago](https://wordpress.org/support/topic/error-incorrect-string-value/#post-4921735) * I’ve uploaded [a new development version](http://downloads.wordpress.org/plugin/rotatingtweets.zip) that uses the same approach as the WordPress Related Posts plug-in to try and fix the problem. * Let me know if it works. * Thread Starter [Pedro_md7](https://wordpress.org/support/users/pedro_md7/) * (@pedro_md7) * [12 years ago](https://wordpress.org/support/topic/error-incorrect-string-value/#post-4921788) * Appearently the issue is that it’s trying to insert an emoticon in the database, and it doesn’t seem to recognize that character. * The error is thrown when it finds \xF0\x9F\x98\x9C in a retweet (in hexadecimal, which seems to translate, applying the encoding to: 😜). * You can see the original tweet in [https://twitter.com/_CarlosRivera/status/467000934070243328](https://twitter.com/_CarlosRivera/status/467000934070243328) * Is there any way to avoid that kind of emoticons, or replace them with a question mark or just remove them? * Thank you in advance. * Plugin Author [Martin Tod](https://wordpress.org/support/users/mpntod/) * (@mpntod) * [12 years ago](https://wordpress.org/support/topic/error-incorrect-string-value/#post-4921799) * Interesting. Thank you for finding that. * It’s not breaking my site – although it also isn’t displaying properly either. * Can you confirm that the wp_options table is using UTF-8 ? * There’s really two problems here – displaying emoji – and not breaking your site! * It may be possible to build in [PHP Emoji](http://code.iamcal.com/php/emoji/) to solve the former problem – but I think it’s still an encoding problem for the latter. * Martin * Plugin Author [Martin Tod](https://wordpress.org/support/users/mpntod/) * (@mpntod) * [12 years ago](https://wordpress.org/support/topic/error-incorrect-string-value/#post-4921801) * The latest version has a `no_emoji` flag that removes emoji from being displayed( although I’m not sure what else it removes!). * However, it doesn’t remove emoji from the feed. * If it doesn’t solve your problem, I suggest we try removing emoji from the feed. * Martin Viewing 8 replies - 1 through 8 (of 8 total) The topic ‘Error Incorrect string value’ is closed to new replies. * ![](https://s.w.org/plugins/geopattern-icon/rotatingtweets.svg) * [Rotating Tweets (Twitter widget and shortcode)](https://wordpress.org/plugins/rotatingtweets/) * [Frequently Asked Questions](https://wordpress.org/plugins/rotatingtweets/#faq) * [Support Threads](https://wordpress.org/support/plugin/rotatingtweets/) * [Active Topics](https://wordpress.org/support/plugin/rotatingtweets/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/rotatingtweets/unresolved/) * [Reviews](https://wordpress.org/support/plugin/rotatingtweets/reviews/) * 8 replies * 2 participants * Last reply from: [Martin Tod](https://wordpress.org/support/users/mpntod/) * Last activity: [12 years ago](https://wordpress.org/support/topic/error-incorrect-string-value/#post-4921801) * Status: not resolved