hey everyone,

i have just imported a tab delimited file into a MySQL table, here is the contents of the file i imported:

first.last,182885
john.citizen,837465
my.name,976548
your.name,8216431
debian.linux,313337
hello.world,847563

the command i used to import it:
Code:
load data infile 'd:/test' into table passwords fields terminated by ',';
(im running this on a windows box)
when i query the database, everything works fine and a username is picked up in full, and i get results, however, things arent displaying properly in the command line client.
for instance, a show all gives me this:

Code:
mysql> select * from passwords;
+--------------+----------+
| userName     | password |
+--------------+----------+
  | rst.last   | 182885
  | hn.citizen | 837465
  | .name      | 976548
 | our.name    | 8216431
  | bian.linux | 313337
| hello.world  | 847563   |
+--------------+----------+
6 rows in set (0.00 sec)
Whilst i am happy that it works, and a query via a PHP page returns the full text of the username, i cannot get it to display right in the CLI, which disturbs me..
any ideas?