[Phpmyadmin-devel] problems with charsets?

[Marc Delisle]

Marc Delisle a écrit:

> 
> 
> 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.

Setting $cfg['AllowAnywhereRecoding'] to TRUE clears the problem
for the data (not for field names).

I did not remember that we can now see the -utf-8 choices in language
drop-down even when $cfg['AllowAnywhereRecoding'] = FALSE;

Marc
> 
> 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=click
> _______________________________________________
> Phpmyadmin-devel mailing list
> Phpmyadmin-devel at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
>