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

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? 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. > > > 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 &lt;marcel.tschopp(a)gmx.net&gt; > >>>>To: Marc Delisle &lt;DelislMa(a)CollegeSherbrooke.qc.ca&gt; > >>>>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 > &gt;&gt;&gt;&gt;&gt;Phpmyadmin-devel(a)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 > &gt;&gt;&gt;Phpmyadmin-devel(a)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 > &gt;&gt;Phpmyadmin-devel(a)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(a)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(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel -- <>

Marc Delisle a écrit: 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

Hi there, Marcel Tschopp wrote: Use MySQL 4.1 :-) MySQL 4.0 / 3.x does not have multi-charset support afaik. So if you access a MySQL 4.0 server with PMA using a language file encoded with charset XY, everything is sent in XY because the user agent sends it in XY. MySQL expoects all clients to use the same charset. Using clients with different charsets results in such problems as long as the clients are not recoding the users' inputs. This is why Michal initially created the recoding functionality: The interface charset could be independant from the db charset. When using MySQL 4.1 we leave all recoding and just tell the MySQL server that we are using the charset XY. The rest is up to MySQL. Regards, -- Alexander M. Turek &lt;rabus(a)users.sourceforge.net&gt; _ __ __ _ _ _ _ __ | |__ _ __ | \/ |_ _ / \ __| |_ __ ___ (_)_ __ | '_ \| '_ \| '_ \| |\/| | | | | / _ \ / _` | '_ ` _ \| | '_ \ | |_) | | | | |_) | | | | |_| |/ ___ \ (_| | | | | | | | | | | | .__/|_| |_| .__/|_| |_|\__, /_/ \_\__,_|_| |_| |_|_|_| |_| |_| |_| |___/ <http://www.phpmyadmin.net>