I have had this problem with PHPMyAdmin many times, and the only way I
know around it, is to go in and do your dump at the console. PHP does
not deal with UTF very well.
- michael dykman
On Thu, Oct 14, 2010 at 5:48 AM, Tompkins Neil
<neil.tompkins@stripped> wrote:
> Hi,
>
> I'm using PHP MyAdmin to backup my MySQL database. The database is of
> type InnoDB
> and encoding used is utf8_unicode_ci. The variables are set as follows :
>
> *MySQL connection collation: **utf8_unicode_ci*
> *MySQL charset: **UTF-8 Unicode (utf8)*
> *character set client: utf8*
> *character set connection: utf8*
> *character set results: utf8*
> *collation connection: **utf8_unicode_ci*
>
> The problem I have is that the foreign characters like ăÿć etc are being
> backed up as scrambled non-readable characters. Any ideas why this is
> happening ?? Are there any other variables I need to check/set ?
>
> Cheers
> Neil
>
--
- michael dykman
- mdykman@stripped
May the Source be with you.
