Using SELECT * truncates first characters.

[aPRSComp]

Hi,

Has anyone seen where using SELECT * truncates characters ?

mysql> SELECT * FROM countries;
+-------------+-----------+
| country | capital |
+-------------+-----------+
|ghanistan | Kabul
|lbania | Tirane
|Algeria | Algiers
mysql> SELECT country FROM countries;
+-------------+
| country |
+-------------+
| Afghanistan |
| Albania |
| Algeria |
+-------------+
3 rows in set (0.00 sec)


c:\countries.csv

Afghanistan, Kabul
Albania, Tirane
Algeria, Algiers

mysql> LOAD DATA LOCAL INFILE 'c:\countries.csv' INTO TABLE countries
-> FIELDS TERMINATED BY ',';
Query OK, 3 rows affected (0.00 sec)
Records: 3 Deleted: 0 Skipped: 0 Warnings: 0

countries TABLE
country VARCHAR(30) NOT NULL
capital VARCHAR(50) NOT NULL
Peter