Thanks Ricardo - Works for me - ...?encoding=utf8
On Mar 24, 9:24 pm, "Ricardo Chimal, Jr." <[email protected]> wrote:
> 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: invalidbytesequencefor encoding
> > "UTF8": 0xe46765
> > HINT: This error can also happen if thebytesequencedoes 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
-~----------~----~----~----~------~----~------~--~---
