Why does 'SELECT * FROM countries' truncate characters and 'SELECT country FROM countries' does not ?

[PRS]

Why does 'SELECT * FROM countries' truncate characters and SELECT country
FROM countries does not ?
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

[replay]

I`ve often used mysql, but never heard about that. sounds like a bug or
something...

which version did you use?
Try the same with a different version.
PRS wrote:

Why does 'SELECT * FROM countries' truncate characters and SELECT country
FROM countries does not ?
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

--

visit: http://www.h4xx0r.ch

[Jeff North]

On Wed, 7 Dec 2005 04:42:06 -0600, in mailing.database.mysql "PRS"
<sw*****@comcast.net> wrote:

| Why does 'SELECT * FROM countries' truncate characters and SELECT country
| FROM countries does not ?
|
|
| 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

Try giving the load data function some more information:

LOAD DATA LOCAL INFILE 'c:\\countries.csv' INTO TABLE countries FIELDS
TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n';

or

LOAD DATA LOCAL INFILE 'c:\\countries.csv' INTO TABLE countries FIELDS
TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY
'\r\n';
---------------------------------------------------------------
jn******@yourpantsyahoo.com.au : Remove your pants to reply
---------------------------------------------------------------