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" <[EMAIL PROTECTED]> To: <mysql@lists.mysql.com> Sent: Wednesday, October 26, 2005 3:25 AM Subject: Re: Error 1406 > 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" <[EMAIL PROTECTED]> 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 > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ 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/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
