From: Tompkins Neil (neil.tompkinsgooglemail.com)
Date: Fri Oct 15 2010 - 04:40:10 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Oh this isn't good. Because the database in on a shared server and I don't
think I've got console access ?

On Thu, Oct 14, 2010 at 6:56 PM, Michael Dykman <mdykmangmail.com> wrote:

> 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.tompkinsgooglemail.com> 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
> - mdykmangmail.com
>
> May the Source be with you.
>

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]