MySQL command line

[AndrewD]

I'm having problems with command line imports into MySQL (windows) of database dumps which include characters outside the usual ascii range (accents, etc). I get errors of the form:

ERROR 1406 at line xx - data too long for column 'xxx'

I can always get round this by changing the characters for standard ascii, but is there a command line switch I'm missing?

[bluesoul]

I looked into the problem (google mysql error 1406) and this bug report (http://bugs.mysql.com/bug.php?id=18908) offers several workarounds, none of which are exceptionally productive.