Re: Error 1406 - James Sherwood - com.mysql.lists.mysql

4 messages in com.mysql.lists.mysqlRe: Error 1406

From	Sent On	Attachments
James Sherwood	25 Oct 2005 10:01
Gleb Paharenko	25 Oct 2005 23:24
James Sherwood	26 Oct 2005 04:44
Gleb Paharenko	26 Oct 2005 14:37

Subject:	Re: Error 1406
From:	James Sherwood (jshe...@rgisolutions.com)
Date:	10/26/2005 04:44:41 AM
List:	com.mysql.lists.mysql

I have since uninstalled 5.0 and installed 4.0

I have found that 4.1 and 5.0 have a VERY hard time with french characters and there are MANY problems assosiated with french characters.

The problem with this one seemed to be when the dump would get put back in, it would throw this error on all the french characters in the dump file. I looked in the file at the spot it was throwing the error and there was a french character, I deleted it from the dump file and it would throw the error at the next one.

The server was installed with Utf8 so that is not the issue and the server from before dumped was utf8 as well.

James

Hello.

I also tried modifying the mediumtext to longtext in the dumpfile but it produces a column with a -1 size for some reason.

Please, could you provide a snip from your dump file.

When I try to input it back into the new 5.0 database, it gives me this error (1406 data too long for column)

Check your sql_mode system variable, if you have there STRICT_ALL_TABLES or STRICT_TRANS_TABLES values. Due to this all warnings are converted to errors and import fails. In 4.0 you might have the same problems, but server just doesn't produce warnings, and you don't know what's going on.

"James Sherwood" <jshe...@rgisolutions.com> wrote:

ello,

I dumped a database from our 4.0 server to a .sql file.

When I try to input it back into the new 5.0 database, it gives me this error (1406 data too long for column)

This works fine on 4.0 but will not work on 5.0.

I also tried modifying the mediumtext to longtext in the dumpfile but it produces a column with a -1 size for some reason.

Any ideas?