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