Character set incorrect on mysql export (phpmyadmin)
 

If you;ve read my other thread you;d notice that I've been attempting to get up a LAMP server up and running...

Done quite well, have centos5.2, virtualmin up and running and fully updated..

Even got to a point where I've dragged across a copy of one of my forums to test out, got the database imported in and everything works fine...
Apart from one thing...

Any accented characters appear as something else (for example the é character appears as é

Tried changing adddefaultcharset in the /etc/httpd/conf from UTF-8 to LATIN1 and rebooted (must learn how to restart apache) but that's had no effect.

..any ideas please :)

---------- Post added at 17:54 ---------- Previous post was at 17:32 ----------

UPDATE: Turns out it's not the server , but a problem with MYPHPADMIN exporting the data..

Anyone know how I can export from mysql (windows command line or phpmyadmin) and keep the encoding correct???

Have changed the thread title to reflect the change in question

Re: Character set incorrect on mysql export (phpmyadmin)
 

I think when you import the data you have to select the encoding type. This was how I solved it last time I had the issue but I can't for the life of me remember which encoding I used.

Re: Character set incorrect on mysql export (phpmyadmin)
 

OK thanks, the data though on the export is converted to UTF-8 for some reason..

Anyway have cured it using dumptimer instead of phpmyadmin ;)

Re: Character set incorrect on mysql export (phpmyadmin)
 

OK, found the problem, phpmyadmin do a UTF-8 ONLY program, it seems that when I did a search for phpmyadmin I found that version and not the full one :)

Re: Character set incorrect on mysql export (phpmyadmin)
 

Glad you got it sorted. Suffered the same thing myself with a VB install.
Was just going to say it's a UTF issue.