Bonjour,
j'ai un problème de caractères accentués qui ne s'affiche pas correctement dans le résultat de la requete.
mysql -u root -p mydb
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.0.67-community-nt MySQL Community Edition (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> SHOW VARIABLES like 'character_set_%';
+--------------------------+---------------------------------------------------------+
| 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 | D:\Program Files\MySQL\MySQL Server 5.0\share\charsets\ |
+--------------------------+---------------------------------------------------------+
8 rows in set (0.03 sec)
mysql>
mysql> select distinct(HardType) from mytable where Country='France' order by HardType;
+--------------------------+
| HardType |
+--------------------------+
....
| Imprimante QualitT Photo |
| Imprimante RTseau |
...
+--------------------------+
16 rows in set (0.90 sec)
comme vous voyez, Qualité ---> QualitT
et Réseau ---> RTseau
Avez vous une idée comment résoudre ce problème?
Merci.
Partager