How do I change my heroku postgres database's encoding?

Question

I tried to insert this into my heroku postgres database.

£

And got this error.

Problem making a comment with ajax. PG::CharacterNotInRepertoire: ERROR: invalid byte sequence for encoding "UTF8": 0xa3

I think my database's encoding is in CP850. How do I change it to UTF-8?

I'm using Sequel ORM

Using a Google search and seeing this answer, do I have to delete my database and create it again?

This doesn't work either.

Sequel::Model.plugin :force_encoding, 'UTF-8'

:encoding => 'utf8'

Pavel Stehule · Accepted Answer · 2015-08-13 10:08:17Z

2

You cannot to change database encoding - not without some pretty ugly magic. The dump, and load is the most simple and safer steps.

answered Aug 13, 2015 at 10:08

Pavel Stehule

46.6k6 gold badges103 silver badges102 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

I've tried with a new blank database and it didn't help.

I don't use a heroku, but I believe, there should be encoding setting for new database. robdodson.me/how-to-setup-postgresql-for-rails-and-heroku

That link doesn't say anything about database encoding.