MySQL Forums :: Character Sets, Collation, Unicode :: problems with charset

Advanced Search

problems with charset
Posted by: Pawel Boryszek ()
Date: July 26, 2010 05:30AM


I have recently hired a new server and I wanted to move my mysql database.

On my old mysql server, via phpmyadmin (Server version: 5.0.90-log, phpMyAdmin - 2.9.2), I exported my .sql file to my hdd.

Text in my old database is in utf8 (with polish special characters), collation is latin2_general_ci. On my old website everything is shown correct:

I have entered into my new mysql server database (MySQL - 5.0.77, phpMyAdmin - and selected import. I picked my .sql file, default character set for file utf8 and clicked import.

Database was correctly imported, but on my new website I see incorrect charset. Static text from html/php is OK, but text from mysql database is like #% or ??.

What should I do to import my .sql file with correct charset?

Options: ReplyQuote

Subject Views Written By Posted
problems with charset 3851 Pawel Boryszek 07/26/2010 05:30AM
Re: problems with charset 1554 Rick James 07/27/2010 11:57PM
Re: problems with charset 1317 Pawel Boryszek 07/28/2010 08:22AM
Re: problems with charset 1270 Rick James 07/28/2010 09:32AM
Re: problems with charset 1195 Pawel Boryszek 07/30/2010 07:12AM
Re: problems with charset 1206 Rick James 07/30/2010 09:23AM
Re: problems with charset 1185 Pawel Boryszek 07/31/2010 05:31AM
Re: problems with charset 1291 Rick James 07/31/2010 09:08AM
Re: problems with charset 1253 Pawel Boryszek 08/03/2010 04:30AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.