hello,
first, some settings : MySQL 5.0.32, under Linux debian etch
the problem is the bad alignment :
mysql> select nom,id from t2;
+------------------+----+
| nom | id |
+------------------+----+
| aàb | 1 |
| été | 2 |
| cçoôeêeèeëi | 3 |
| c'est tout | 4 |
+------------------+----+
AS YOU SEE, THE DISPLAY IS NOT GOOD AT ALL :
how could I got the column WELL ALIGNED ???
thank you.
WHAT I HAVE DONE :
mysql> SHOW VARIABLES LIKE 'character_set_system';
+----------------------+-------+
| Variable_name | Value |
+----------------------+-------+
| character_set_system | utf8 |
+----------------------+-------+
I create a tiny test table, loaded with a file data2 made under
editor vi,
and on wich the unix command "file data2" returns :
data2: UTF-8 Unicode text
Of course, there is no "space" before each "end of line" character
mysql> CREATE TABLE t2 (id int(10) unsigned NOT NULL auto_increment,nom
varchar(255) NOT NULL,PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT
CHARSET=UTF8;
after loading the file data2, I display the content
_-¯-_-¯-_-¯-_-¯-_
Gilles Missonnier
IAP - [EMAIL PROTECTED]
01 44 32 81 36
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
