Importing Tomcat Access Log

[Andrew Taylor]

I am putting this in the newbie forum since I am a bit of a newb.

I have setup a table in mysql to take in data from a tomcat webaccess log.
The fields are space delimited and so are the lines. Mysql does not seem to like this. I am using the following query to import the file, and i constantly get Error 1406 - Data to long for column at row x.

This just continues to happen i go increease the varchar size and it just happens again on the next colum so on and so on, and I know the data is not 100 char long.

Any help with this would be great.

Thanks