heroku db:pull to local mysql utf8

Question

I'm trying to dump a heroku db with heroku db:pull

The problem is that the data that has special character (like 'ñ') are not store propertly.

I see that the local tables are created with default charset=latin1

is there a way that the heroku script create the table with charset utf8?

score 1 · Answer 1 · answered Oct 14 '13 at 19:24

1

heroku db:push -t tables mysql://user:pass@localhost/mydb encoding=UTF8 --confirm myapp

answered Oct 14 '13 at 19:24

kamus

score 0 · Accepted Answer · edited May 23 '17 at 10:25

0

The solution is to set the default charset in mysql server itself like in:

doing that and after restart the local mysql, heroku db:pull will create the tables with the default utf8 charset.

edited May 23 '17 at 10:25

Community

answered Jul 16 '13 at 19:48

David Sedeño

2 Answers2