Title: Deployment Error |  Incorrect string value for column 'option_value'
Last modified: August 30, 2016

---

# Deployment Error | Incorrect string value for column 'option_value'

 *  Resolved [Sparkblender](https://wordpress.org/support/users/sparkblender/)
 * (@sparkblender)
 * [10 years, 5 months ago](https://wordpress.org/support/topic/deployment-error-incorrect-string-value-for-column-option_value/)
 * Great Plugin!
 * I’m migrating a site running WP 4.2.2. (backed up with Duplicator 0.5.28) on 
   a Server running MySQL 5.6.24, to another Server running MySQL 5.7.9.
 * I’m getting only one Deployment error (installer-log.txt):
 * > **ERROR** database error write ‘Incorrect string value: ‘\xF0\x9F\x98\x89″ …’
   > for column ‘option_value’ at row 1′ – [sql=INSERT INTO`tbl_options`VALUES(“
   > 15872”, “_transient_feed_7fa907073bddbc2f…]
 * After searching for several hours, it seems like the error may be related to 
   the use of different character sets. Nevertheless, destination database seems
   to be using the same character sets as the source database, which doesn’t explain
   the above assumption:
 * > # character_set_client=utf8mb4
   >  # character_set_connection=utf8mb4 # character_set_database
   > =latin1 # character_set_filesystem=binary # character_set_results=utf8mb4 #
   > character_set_server=latin1 # character_set_system=utf8 # collation_connection
   > =utf8mb4_unicode_ci # collation_database=latin1_swedish_ci # collation_server
   > =latin1_swedish_ci
 * Any ideas what could be causing this Deployment error?
 * Thanks!
 * [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, 5 months ago](https://wordpress.org/support/topic/deployment-error-incorrect-string-value-for-column-option_value/#post-6775812)
 * Hey Sparkblender,
 * What database build mode are you using ‘PHP’ or ‘mysqldump’?
 * Thanks~
 *  Thread Starter [Sparkblender](https://wordpress.org/support/users/sparkblender/)
 * (@sparkblender)
 * [10 years, 5 months ago](https://wordpress.org/support/topic/deployment-error-incorrect-string-value-for-column-option_value/#post-6775813)
 * Hi Cory,
    I was trying to install on MAMP Server when the error occurred. I ended
   up installing on my host, with no errors. Thanks for following up!
 *  [Cory Lamle](https://wordpress.org/support/users/corylamleorg/)
 * (@corylamleorg)
 * [10 years, 5 months ago](https://wordpress.org/support/topic/deployment-error-incorrect-string-value-for-column-option_value/#post-6775814)
 * That is good to hear!
 * Cheers~

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

The topic ‘Deployment Error | Incorrect string value for column 'option_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

 * [character set](https://wordpress.org/support/topic-tag/character-set/)
 * [MySQL](https://wordpress.org/support/topic-tag/mysql/)
 * [option_value](https://wordpress.org/support/topic-tag/option_value/)

 * 3 replies
 * 2 participants
 * Last reply from: [Cory Lamle](https://wordpress.org/support/users/corylamleorg/)
 * Last activity: [10 years, 5 months ago](https://wordpress.org/support/topic/deployment-error-incorrect-string-value-for-column-option_value/#post-6775814)
 * Status: resolved