Christian Hammers a écrit :
Hello

On 2006-09-04 tech wrote:

Package: mysql-dfsg-5.1
Version: accentued characters doesn't show right
Severity: important

Since I upgraded to the last testing version of mysql (5.0.24-3)
all accentuated characters in databases are rotten.

The bug report says "mysql-dfsg-5.1" above? This is a version that
is only available in experimental. Please show dpkg -l "*mysql*" | grep ^.i
to see what package versions you really have installed.

As I wrote before, mysql version is 5.0.24-3
$ dpkg -l "*mysql*" | grep ^.i
ii  libdbd-mysql-perl          3.0006-1         A Perl5 database interface to 
the MySQL data
ii  libmysqlclient10           3.23.56-3        LGPL-licensed client library 
for MySQL datab
ii  libmysqlclient12           4.0.24-10sarge2  mysql database client library
ii  libmysqlclient14           4.1.15-3         mysql database client library
ii  libmysqlclient15off        5.0.24-3         mysql database client library
ii  mysql-client               5.0.24-3         mysql database client (current 
version)
ii  mysql-client-5.0           5.0.24-3         mysql database client binaries
ii  mysql-common               5.0.24-3         mysql database common files 
(e.g. /etc/mysql
ii  mysql-query-browser-common 1.1.18-5         Architecture independent files 
for MySQL Que
ii  mysql-server               5.0.24-3         mysql database server (current 
version)
ii  mysql-server-5.0           5.0.24-3         mysql database server binaries
ii  php4-mysql                 4.4.2-1.1        MySQL module for php4
ii  webmin-mysql               1.220-2          mysql-server control module for 
webmin


I always used iso-8859-15 as charset for all my databases, but it seems that
the upgrade modified something in the parameters to use utf-8 instead.  I
would like to know how I could get back the previous behaviour.  For the
moment all my databases are unusable

As far as I know that have been no changes to the locales. Can you show
        SHOW CREATE DATABASE xxx;
SHOW CREATE DATABASE parnasse
=>
CREATE DATABASE `parnasse` /*!40100 DEFAULT CHARACTER SET latin1 COLLATE 
latin1_general_ci */

        SHOW CREATE TABLE xxx.yyy;
SHOW CREATE TABLE CLIENTS
=>
CREATE TABLE `CLIENTS` (\n `ID_CLIENT` int(11) NOT NULL auto_increment,\n `TITRE` varchar(10) character set latin1 default NULL,\n `TITRE2` varchar(255) character set latin1 default NULL,\n `NOM` varchar(100) character set latin1 NOT NULL default '',\n `PRENOM` varchar(100) character set latin1 NOT NULL default '',\n `ADRESSE` varchar(100) character set latin1 default NULL,\n `CODE_POSTAL` varchar(5) character set latin1 default NULL,\n `VILLE` varchar(100) character set latin1 default NULL,\n `TELEPHONE` varchar(25) character set latin1 default NULL,\n `E_MAIL` varchar(100) character set latin1 default NULL,\n `ZONE_GEOGRAPHIQUE` smallint(6) default NULL,\n `DATE_SAISIE` datetime NOT NULL default '0000-00-00 00:00:00',\n `DATE_DE_NAISSANCE` date default NULL,\n `OBSERVATIONS` varchar(255) character set latin1 default NULL,\n `SEXE` char(1) character set latin1 NOT NULL default '',\n `TARIF` smallint(6) NOT NULL default '0',\n `LOGIN` varchar(20) character set latin1 default NULL,\n `PASSWORD` varchar(20) character set latin1 default NULL,\n `VALIDATION` tinyint(1) default '0',\n PRIMARY KEY (`ID_CLIENT`)\n) ENGINE=MyISAM AUTO_INCREMENT=1212 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci

I have many of problems in the PRENOM field of this table because many french 
firstnames contain accentuated characters

        SHOW VARIABLES LIKE "char%";
in phpmyadmin opened with "French (iso-8859-15)"
=>
character_set_client            utf8
character_set_connection        latin1
character_set_database          latin1
character_set_filesystem        binary
character_set_results           utf8
character_set_server            latin1
character_set_system            utf8
character_sets_dir              /usr/share/mysql/charsets/

logged in mysql
=>
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | latin1                     |
| character_set_connection | latin1                     |
| character_set_database   | latin1                     |
| character_set_filesystem | binary                     |
| character_set_results    | latin1                     |
| character_set_server     | latin1                     |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+

using MySQL Query Browser
=>
character_set_client            utf8
character_set_connection        utf8
character_set_database          latin1
character_set_filesystem        binary
character_set_results           utf8
character_set_server            latin1
character_set_system            utf8
character_sets_dir              /usr/share/mysql/charsets/

and getting the result from the web server where I use this database, I get
            [Variable_name] => character_set_client
            [Value] => latin1

            [Variable_name] => character_set_connection
            [Value] => latin1

            [Variable_name] => character_set_database
            [Value] => latin1

            [Variable_name] => character_set_filesystem
            [Value] => binary

            [Variable_name] => character_set_results
            [Value] => latin1

            [Variable_name] => character_set_server
            [Value] => latin1

            [Variable_name] => character_set_system
            [Value] => utf8

            [Variable_name] => character_sets_dir
            [Value] => /usr/share/mysql/charsets/


to see which charset is configured for your tables.

You might also want to lookup dev.mysql.com -> Manual -> History to see
if there have been any changes in between 5.0.23 and 5.0.24 that are
related.

the upgrade was exactly from 5.0.24-1 to 5.0.24-3 and I didn't allow apt-get to 
replace my /etc/mysql/my.cnf during install
this is /var/log/dpkg.log extract

2006-09-02 12:23:31 upgrade mysql-common 5.0.24-1 5.0.24-3
2006-09-02 12:23:31 status half-configured mysql-common 5.0.24-1
2006-09-02 12:23:31 status unpacked mysql-common 5.0.24-1
2006-09-02 12:23:31 status half-installed mysql-common 5.0.24-1
2006-09-02 12:23:31 status half-installed mysql-common 5.0.24-1
2006-09-02 12:23:31 status unpacked mysql-common 5.0.24-3
2006-09-02 12:23:31 status unpacked mysql-common 5.0.24-3
2006-09-02 12:23:31 upgrade libmysqlclient15off 5.0.24-1 5.0.24-3
2006-09-02 12:23:31 status half-configured libmysqlclient15off 5.0.24-1
2006-09-02 12:23:31 status unpacked libmysqlclient15off 5.0.24-1
2006-09-02 12:23:31 status half-installed libmysqlclient15off 5.0.24-1
2006-09-02 12:23:31 status half-installed libmysqlclient15off 5.0.24-1
2006-09-02 12:23:31 status unpacked libmysqlclient15off 5.0.24-3
2006-09-02 12:23:31 status unpacked libmysqlclient15off 5.0.24-3
2006-09-02 12:23:31 upgrade mysql-client 5.0.24-1 5.0.24-3
2006-09-02 12:23:31 status half-configured mysql-client 5.0.24-1
2006-09-02 12:23:31 status unpacked mysql-client 5.0.24-1
2006-09-02 12:23:31 status half-installed mysql-client 5.0.24-1
2006-09-02 12:23:31 status half-installed mysql-client 5.0.24-1
2006-09-02 12:23:31 status unpacked mysql-client 5.0.24-3
2006-09-02 12:23:31 status unpacked mysql-client 5.0.24-3
2006-09-02 12:23:31 upgrade mysql-client-5.0 5.0.24-1 5.0.24-3
2006-09-02 12:23:31 status half-configured mysql-client-5.0 5.0.24-1
2006-09-02 12:23:31 status unpacked mysql-client-5.0 5.0.24-1
2006-09-02 12:23:31 status half-installed mysql-client-5.0 5.0.24-1
2006-09-02 12:23:33 status half-installed mysql-client-5.0 5.0.24-1
2006-09-02 12:23:33 status unpacked mysql-client-5.0 5.0.24-3
2006-09-02 12:23:33 status unpacked mysql-client-5.0 5.0.24-3
2006-09-02 12:23:33 upgrade mysql-server 5.0.24-1 5.0.24-3
2006-09-02 12:23:33 status half-configured mysql-server 5.0.24-1
2006-09-02 12:23:33 status unpacked mysql-server 5.0.24-1
2006-09-02 12:23:33 status half-installed mysql-server 5.0.24-1
2006-09-02 12:23:33 status half-installed mysql-server 5.0.24-1
2006-09-02 12:23:33 status unpacked mysql-server 5.0.24-3
2006-09-02 12:23:33 status unpacked mysql-server 5.0.24-3
2006-09-02 12:23:33 upgrade mysql-server-5.0 5.0.24-1 5.0.24-3
2006-09-02 12:23:33 status half-configured mysql-server-5.0 5.0.24-1
2006-09-02 12:23:42 status unpacked mysql-server-5.0 5.0.24-1
2006-09-02 12:23:42 status half-installed mysql-server-5.0 5.0.24-1
2006-09-02 12:23:46 status half-installed mysql-server-5.0 5.0.24-1
2006-09-02 12:23:47 status unpacked mysql-server-5.0 5.0.24-3
2006-09-02 12:23:47 status unpacked mysql-server-5.0 5.0.24-3

As I didn't find Manual -> History on dev.mysql.com, I looked into changelogs, 
but
I didn't see any mention of such change in the changelog.


bye

Reply via email to