Title: **ERROR** database error write 'Incorrect string value
Last modified: August 31, 2016

---

# **ERROR** database error write 'Incorrect string value

 *  Resolved [franksousa](https://wordpress.org/support/users/franksousa/)
 * (@franksousa)
 * [10 years, 1 month ago](https://wordpress.org/support/topic/error-database-error-write-incorrect-string-value/)
 * Hello
 * I want to thank and say that this plugin is wonderful. But I have a problem that
   never happened.
    I’m migrating a site to my local server and receive a single
   error that is this:
 * **ERROR** database error write ‘Incorrect string value: ‘\xF0\x9F\x9B\xB3, …’
   for column ‘option_value’ at row 1′ – [sql=INSERT INTO `wp_options` VALUES(“4259”,“
   _transient_feed_ac0b00fe65abe10e0c…]
    ERRORS FOUND: 1 DROP TABLE: removed (0)
   tables QUERIES RAN: 3912
 * I left Grouping (Collation) the same way as the original seat but failed. What
   can I do to fix?
 * Grateful!
 * [https://wordpress.org/plugins/duplicator/](https://wordpress.org/plugins/duplicator/)

Viewing 3 replies - 1 through 3 (of 3 total)

 *  [Cory Lamle](https://wordpress.org/support/users/corylamleorg/)
 * (@corylamleorg)
 * [10 years, 1 month ago](https://wordpress.org/support/topic/error-database-error-write-incorrect-string-value/#post-7349298)
 * Hey Frank,
 * You may take a look at this thread and see if it helps:
    [https://wordpress.org/support/topic/database-error-when-duplicate-in-localhost?replies=3](https://wordpress.org/support/topic/database-error-when-duplicate-in-localhost?replies=3)
 * Cheers~
 *  Thread Starter [franksousa](https://wordpress.org/support/users/franksousa/)
 * (@franksousa)
 * [10 years, 1 month ago](https://wordpress.org/support/topic/error-database-error-write-incorrect-string-value/#post-7349325)
 * I’m working on Windows 10. There is this file. My version of My SQL is the latest.
   Grateful!
 *  [Cory Lamle](https://wordpress.org/support/users/corylamleorg/)
 * (@corylamleorg)
 * [10 years, 1 month ago](https://wordpress.org/support/topic/error-database-error-write-incorrect-string-value/#post-7349368)
 * I think this may be outside of what Duplicator can fix, here is a thread that
   looks promising:
    [http://stackoverflow.com/questions/1168036/how-to-fix-incorrect-string-value-errors](http://stackoverflow.com/questions/1168036/how-to-fix-incorrect-string-value-errors)

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘**ERROR** database error write 'Incorrect string value’ is closed to 
new replies.

 * ![](https://ps.w.org/duplicator/assets/icon-256x256.png?rev=2906985)
 * [Duplicator - Backups & Migration Plugin - Cloud Backups, Scheduled Backups, & More](https://wordpress.org/plugins/duplicator/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/duplicator/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/duplicator/)
 * [Active Topics](https://wordpress.org/support/plugin/duplicator/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/duplicator/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/duplicator/reviews/)

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)
 * [string](https://wordpress.org/support/topic-tag/string/)
 * [value](https://wordpress.org/support/topic-tag/value/)

 * 3 replies
 * 2 participants
 * Last reply from: [Cory Lamle](https://wordpress.org/support/users/corylamleorg/)
 * Last activity: [10 years, 1 month ago](https://wordpress.org/support/topic/error-database-error-write-incorrect-string-value/#post-7349368)
 * Status: resolved