Re: Error 1406

2005-10-27 Thread Gleb Paharenko
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

Re: Error 1406

2005-10-26 Thread Gleb Paharenko
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

Re: Error 1406

2005-10-26 Thread James Sherwood
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

Error 1406

2005-10-25 Thread James Sherwood
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