what's the database encoding of your local database?

try
heroku db:push mysql://username:passw...@localhost/db_name?encoding=utf8
or
heroku db:push mysql://username:passw...@localhost/db_name?encoding=latin1
or substitute the encoding with your local database encoding


On Mar 24, 9:21 am, "jo...@stixy" <[email protected]> wrote:
> When I try to run heroku db:push mysql://username:passw...@localhost/db_name
> i get an error as soon as a field in the database has a non latin
> character (such as åäö). It througs this error:
>
> Taps Server Error: PGError ERROR:  invalid byte sequence for encoding
> "UTF8": 0xe46765
> HINT:  This error can also happen if the byte sequence does not match
> the encoding expected by the server, which is controlled by
> "client_encoding".
>
> Is the database setup to handle utf8 encoded data? What am I doing
> wrong?
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"Heroku" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to 
[email protected]
For more options, visit this group at 
http://groups.google.com/group/heroku?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to