Tuesday, 10 September 2013

export accents wrong phpmyadmin

export accents wrong phpmyadmin

I have a big problem into my server.
I have to export a database, but when I try and import it accent are wrong.
For example I hava table with collation latin1_swedish_ci and a row into
the old database like this:
Das Nationale Transplantation –Centrum
I export the table from my phpmyadmin because I don't have access to the
ssh of this server. The export is .sql with compatibility mode:NONE
I create the table into new server in latin1_swedish_ci and try to import
the sql the record now is this:
Das Nationale Transplantation â??Centrum
How can I export my table without lost this accent?

No comments:

Post a Comment