[Phpmyadmin-devel] problems with charsets?

[Marc Delisle]

Marcel Tschopp a écrit:

>>Sorry Marcel, I should have told you that I was using mysql extension
>>on MySQL 4.0.16.
> 
> I'm I right when I say that with above configuration and current cvs
> tree of PMA it WON'T work?
> Or did it work with mysql-ext and mysql4.0.16?

Marcel,

the problem happens with mysql-ext and 4.0.16. I meant
that now I understand why you were not seeing the problem, because
you must be using mysqli most of the time!

Marc
> 
> Sorry for that question, but yet I'm unsure :-)
> 
> Marcel
>  
> 
>>Marcel Tschopp a écrit:
>>
>>
>>>Hi people,
>>>
>>>can anyone help? 
>>>
>>>The problem does NOT occure when using:
>>>- the new mysqli extension OR with mysql >= 4.1 (couldn't test mysql-ext
>>>with mysql >= 4.1)
>>>- phpMyAdmin <= 2.5.6.
>>
>>Sorry Marcel, I should have told you that I was using mysql extension
>>on MySQL 4.0.16.
>>
>>Of course, special characters in data are also affected.
>>
>>Marc
>>
>>>You can test it as following:
>>>In UTF8 mode (eg: en-utf-8) create a new field 'tést' on a table. Then
>>>switch to an ISO mode (eg: en-iso-8859-1) and look at the table
>>>structure. Now the character 'é' has been replaced...
>>>
>>>Anyone knows how to solve the problem?
>>>
>>>Regards,
>>>Marcel
>>>
>>>
>>>
>>>
>>>>Marcel Tschopp a écrit:
>>>>
>>>>
>>>>
>>>>>Hi
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>>first, any particular reason you did not answer to
>>>>>>the list?
>>>>>
>>>>>No...
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>>About the column, yes this column was created a long
>>>>>>time ago using an ISO charset. Using 2.5.6 I could
>>>>>>switch from one charset to the other and still see
>>>>>>my column name intact. Will this problem be the
>>>>>>normal situation now with the new charset behavior?
>>>>>
>>>>>I think the new charset behaviour SHOULD not make such problems... if it
>>>>>does, I will try to correct that. I'll search for the problem today
>>>>>evening again.
>>>>>
>>>>>Marcel
>>>>
>>>>Marcel,
>>>>I reproduced the problem also on our demo version of phpmyadmin.net.
>>>>
>>>>Marc
>>>>
>>>>
>>>>>
>>>>>
>>>>>>Hi Marcel,
>>>>>>first, any particular reason you did not answer to
>>>>>>the list?
>>>>>>About the column, yes this column was created a long
>>>>>>time ago using an ISO charset. Using 2.5.6 I could
>>>>>>switch from one charset to the other and still see
>>>>>>my column name intact. Will this problem be the
>>>>>>normal situation now with the new charset behavior?
>>>>>>Marc
>>>>>>
>>>>>>-----Original Message-----
>>>>>>From: Marcel Tschopp <marcel.tschopp at gmx.net>
>>>>>>To: Marc Delisle <DelislMa at CollegeSherbrooke.qc.ca>
>>>>>>Date: Mon, 12 Apr 2004 18:53:15 +0200
>>>>>>Subject: Re: [Phpmyadmin-devel] problems with charsets?
>>>>>>
>>>>>>hi marc,
>>>>>>
>>>>>>hmm... strange. on my machine it works perfectly (i had to change the
>>>>>>browsers character coding manually, but thats all)
>>>>>>did you try to create a test column in iso mode and then switch to utf8?
>>>>>>
>>>>>>greets
>>>>>>marcel
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>>Hi,
>>>>>>>
>>>>>>>looks like a very recent change in HEAD causes me some problems.
>>>>>>>Using a utf-8 language (tried French and German), my column names
>>>>>>>who have french accents in them like "prénom" are displayed wrong.
>>>>>>>
>>>>>>>Someone can confirm this?
>>>>>>>
>>>>>>>Marc
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>-------------------------------------------------------
>>>>>>>This SF.Net email is sponsored by: IBM Linux Tutorials
>>>>>>>Free Linux tutorial presented by Daniel Robbins, President and CEO of
>>>>>>>GenToo technologies. Learn everything from fundamentals to system
>>>>>>>administration.http://ads.osdn.com/?ad_id70&alloc_id638&op
ick
>>>>>>>_______________________________________________
>>>>>>>Phpmyadmin-devel mailing list
>>>>>>>Phpmyadmin-devel at lists.sourceforge.net
>>>>>>>https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>-------------------------------------------------------
>>>>>This SF.Net email is sponsored by: IBM Linux Tutorials
>>>>>Free Linux tutorial presented by Daniel Robbins, President and CEO of
>>>>>GenToo technologies. Learn everything from fundamentals to system
>>>>>administration.http://ads.osdn.com/?ad_id70&alloc_id638&op=click
>>>>>_______________________________________________
>>>>>Phpmyadmin-devel mailing list
>>>>>Phpmyadmin-devel at lists.sourceforge.net
>>>>>https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
>>>>>
>>>>
>>>>
>>>>
>>>>-------------------------------------------------------
>>>>This SF.Net email is sponsored by: IBM Linux Tutorials
>>>>Free Linux tutorial presented by Daniel Robbins, President and CEO of
>>>>GenToo technologies. Learn everything from fundamentals to system
>>>>administration.http://ads.osdn.com/?ad_id70&alloc_id638&op
ick
>>>>_______________________________________________
>>>>Phpmyadmin-devel mailing list
>>>>Phpmyadmin-devel at lists.sourceforge.net
>>>>https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
>>>
>>>
>>>
>>>
>>>-------------------------------------------------------
>>>This SF.Net email is sponsored by: IBM Linux Tutorials
>>>Free Linux tutorial presented by Daniel Robbins, President and CEO of
>>>GenToo technologies. Learn everything from fundamentals to system
>>>administration.http://ads.osdn.com/?ad_id70&alloc_id638&op=click
>>>_______________________________________________
>>>Phpmyadmin-devel mailing list
>>>Phpmyadmin-devel at lists.sourceforge.net
>>>https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
>>>
>>
>>
>>
>>-------------------------------------------------------
>>This SF.Net email is sponsored by: IBM Linux Tutorials
>>Free Linux tutorial presented by Daniel Robbins, President and CEO of
>>GenToo technologies. Learn everything from fundamentals to system
>>administration.http://ads.osdn.com/?ad_id70&alloc_id638&op
ick
>>_______________________________________________
>>Phpmyadmin-devel mailing list
>>Phpmyadmin-devel at lists.sourceforge.net
>>https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
> 
>