SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 06:36 AM
| ||||
| ||||
 problems with accents and display alignement 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 - gimi@iap.fr 01 44 32 81 36      |
 |
« MySQL upgrade from 5.0.32 to 5.0.42 broke replication
|
Re: maximum number of records in a table »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 09:14 AM.
