Database Import Error

[defchino]

I'm moving an installation of ZC 1.3.6 on a server running MySQL v4.1.21 to a new server running MySQL 5.

While trying to import the database to the new server I get this error:

#1406 - Data too long for column 'products_description' at row 1

If I remove the Insert for the product description table everything else imports fine. The first record looks like this:

(184, 1, 'Explore 14" Laptop Messenger Satchel - Copper', 'When you need the essentials and more, the Explore holds just that little extra. With a padded computer nest, spacious central compartment, side pen & key pockets, plus a media player cache… you’re set to go.', '', 21)

This is the structure:

CREATE TABLE IF NOT EXISTS `zen_products_description` (
`products_id` int(11) NOT NULL auto_increment,
`language_id` int(11) NOT NULL default '1',
`products_name` varchar(64) NOT NULL default '',
`products_description` text,
`products_url` varchar(255) default NULL,
`products_viewed` int(5) default '0',
PRIMARY KEY (`products_id`,`language_id`),
KEY `idx_products_name_zen` (`products_name`)
)

I'm using PHPMyAdmin v2.6.1-pl3 if that should matter.

Thanks in advance for any help!

[kobra]

Try changing (remove spaces)

14"  to 14 & # 147;

And you should upgrade as full support for mysql 5.x is in later versions

[defchino]

Thanks for the reply.

I'm still getting the same error after replacing the double quotes with '&#147'.

[defchino]

Anyone else have any ideas?