Mysql error when transporting database

[pilot]

I am transporting the database between my work machine and my home machine, and when I load the database into my home machine I get this error:

CREATE TABLE `address_book` (
`address_book_id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`customers_id` int( 11 ) NOT NULL default '0' ,
`entry_gender` char( 1 ) NOT NULL default '' ,
`entry_company` varchar( 32 ) default NULL ,
`entry_firstname` varchar( 32 ) NOT NULL default '' ,
`entry_lastname` varchar( 32 ) NOT NULL default '' ,
`entry_street_address` varchar( 64 ) NOT NULL default '' ,
`entry_suburb` varchar( 32 ) default NULL ,
`entry_postcode` varchar( 10 ) NOT NULL default '' ,
`entry_city` varchar( 32 ) NOT NULL default '' ,
`entry_state` varchar( 32 ) default NULL ,
`entry_country_id` int( 11 ) NOT NULL default '0' ,
`entry_zone_id` int( 11 ) NOT NULL default '0' ,
PRIMARY KEY ( `address_book_id` ) ,
KEY `idx_address_book_customers_id_zen` ( `customers_id` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =8;



MySQL said:
#1064 - You have an error in your SQL syntax.**Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=8' at line 17

What I find odd is that home mysql is version 3.23.49 and work is 4.1.19 and have installed zen-cart version 1.3.0.2 on both machines and it works fine on both, so why is there an incompatability between the two databases, surely they would install the same structure of databases ?

using php 4.4.2

I am trying to duplicate my work set up to work at home. 1st step was to load my work database at home

[pilot]

The only way the database would load is by deleting

DEFAULT CHARSET = latin1

This has resulted though in the  before the £ sign like below.

£0.65

never experienced this before ?

[Merlinpa1969]

this is an issue between the versions,
I have had it happen

Yes do a search for
DEFAULT CHARSET=latin1 and replace with blank

do the same with the
Â

using search and replace works well,
would suggest upgrading local machine to php 4.1

[pilot]

This has resulted though in the  before the £ sign like below.

£0.65

never experienced this before ?

please ignore this bit, I found the  before the £ in the admin/currency . . . . no idea how it got there ?

[superprg]

please ignore this bit, I found the  before the £ in the admin/currency . . . . no idea how it got there ?

During file transfer or numbers or records being odd

[hondauser85]

so how was this fixed again as i have the same problem