MySQL ODBC Connector

Author

Error 1406

James Sherwood

2005-10-27, 7:47 am

------ =_NextPart_000_19AC_
01C5D96C.A6D80F00
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hello,

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?

Thanks,
James
------ =_NextPart_000_19AC_
01C5D96C.A6D80F00--

Gleb Paharenko

2005-10-27, 7:47 am

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" < jsherwood@rgisolutio
ns.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?
>
>Thanks,
>James

--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@ensita.net
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

James Sherwood

2005-10-27, 7:47 am

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

----- Original Message -----
From: "Gleb Paharenko" <gleb.paharenko@ensita.net>
To: <mysql@lists.mysql.com>
Sent: Wednesday, October 26, 2005 3:25 AM
Subject: Re: Error 1406

> Hello.
>
produces a column[color=darkred
]
>
> Please, could you provide a snip from your dump file.
>
error (1406 data[color=darkred]
>
> 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" < jsherwood@rgisolutio
ns.com> wrote:
error (1406 data[color=darkred]
produces a column[color=darkred
]
>
>
> --
> For technical support contracts, goto https://order.mysql.com/?ref=ensita
> This email is sponsored by Ensita.NET http://www.ensita.net/
> __ ___ ___ ____ __
> / |/ /_ __/ __/ __ \/ / Gleb Paharenko
> / /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@ensita.net
> /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
> <___/ www.mysql.com
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/mysql? unsub.../> olutions.com
>
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Gleb Paharenko

2005-10-27, 7:47 am

Hello.

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

Complete UTF8 support has appeared only in 4.1 branch.

> 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

Have you tried to perform a dump with --quote-names option?

James Sherwood wrote:
> 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
>
>
> ----- Original Message ---

--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@ensita.net
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Sponsored Links