Why doesn't MySQL upload my data properly?

Mysql doesnt show the entire text I input?

• I'm new at this. I created a new table called matches, used a txt file and the load data local infile command to load it into the new table. Everything loaded properly but when I use "select * from matches; syntax I get this: http://static3.filefront.com/images/personal/m/mrLiioadin/121392/pkzdpiqwkh.jpg Where it should say Argentina in the first column it shows it quite differently. Oddly, if I use select * from matches where nation = 'Argentina'; I doesn't have a problem finding the instance, but it still doesn't display it properly. Could this be related to me using VARCHAR(32) in the definitions for the table?

• Answer:

  Double check your import file. It looks like you may have a unicode character, stay apostrophe or a stray comma in it. Also, try using: % mysqldump --opt database_name matches ...and see what MySQL actually outputs. DSL