Re: [Phpmyadmin-devel] problems with charsets?
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
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@gmx.net> To: Marc Delisle <DelislMa@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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
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@gmx.net> To: Marc Delisle <DelislMa@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@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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
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
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@gmx.net> To: Marc Delisle <DelislMa@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@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@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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
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@gmx.net> To: Marc Delisle <DelislMa@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@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@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@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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
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?
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@gmx.net> To: Marc Delisle <DelislMa@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@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@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@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@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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
-- <>
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@gmx.net> To: Marc Delisle <DelislMa@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@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@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@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@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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
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@gmx.net> To: Marc Delisle <DelislMa@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@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@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@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@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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
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.
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...
Marcel, here, the problem is only on the field name as seen on the Browse page. On Structure or Search page, the field name is ok in both ISO and UTF-8 mode. Marc
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@gmx.net> To: Marc Delisle <DelislMa@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@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@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@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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
Hi there, Marcel Tschopp wrote:
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?
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 <rabus@users.sourceforge.net> _ __ __ _ _ _ _ __ | |__ _ __ | \/ |_ _ / \ __| |_ __ ___ (_)_ __ | '_ \| '_ \| '_ \| |\/| | | | | / _ \ / _` | '_ ` _ \| | '_ \ | |_) | | | | |_) | | | | |_| |/ ___ \ (_| | | | | | | | | | | | .__/|_| |_| .__/|_| |_|\__, /_/ \_\__,_|_| |_| |_|_|_| |_| |_| |_| |___/ <http://www.phpmyadmin.net>
On 15.04.2004 23:05 +0200, Alexander M. Turek wrote:
Hi there,
Marcel Tschopp wrote:
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?
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.
Exactly.
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.
Shouldn't we with MySQL 4.1 offer just unicode translations? -- Regards Michal Čihař http://cihar.com
participants (4)
-
Alexander M. Turek -
Marc Delisle -
Marcel Tschopp -
Michal Čihař