incorrect string value

I imported some sms messages with emoticons in them and even though I’m setup for utf8 encoding such as foreign languages, these emoticons raise ‘incorrect string value’ error

Hi, have you defined on the very first line of your ruby file UTF encoding as follows:

encoding: utf-8

``

You say when you are importing to DB? Usually you should have utf8mb4 as your encoding in that case :slight_smile:

https://blog.arkency.com/2015/05/how-to-store-emoji-in-a-rails-app-with-a-mysql-database/

or

https://www.google.co.uk/search?q=rails+mysql+emoji