[Phpmyadmin-devel] problems with charsets?

Marc Delisle DelislMa at CollegeSherbrooke.qc.ca
Tue Apr 13 12:59:31 CEST 2004


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
> 





More information about the Developers mailing list