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'

Have you tried to dump and recreate your DB? – Igor Romanchenko Aug 13 '15 at 10:07 — Igor Romanchenko, Aug 13 '15 at 10:07
I've created a new database and I still have that issue. – desbest Aug 13 '15 at 10:47 — desbest, Aug 13 '15 at 10:47

score 2 · Answer 1 · answered Aug 13 '15 at 10:08

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 '15 at 10:08

Pavel Stehule

I've tried with a new blank database and it didn't help. – desbest Aug 13 '15 at 10:51
I don't use a heroku, but I believe, there should be encoding setting for new database. http://robdodson.me/how-to-setup-postgresql-for-rails-and-heroku/ – Pavel Stehule Aug 13 '15 at 10:58
That link doesn't say anything about database encoding. – desbest Aug 13 '15 at 14:21

1 Answers1