MySQL and Apostrophes

[Hugh Mansfield]

I am doing an INSERT INTO statement to bring in data.


So whats the deal ..... i have tried all three below and still no joy, it doesn't like apostrophes no matter what i do.


1. (00000006,Colin,O\’Brien,Cork,Irish,000005),

2. (00000006,"Colin","O\’Brien","Cork","Irish",000005),

3. (00000006,'Colin','O\’Brien','Cork','Irish',000005),


The data types are


MemberNo integer not null,
FIrstName Varchar(32) not null default '',
Surname Varchar(32) not null default '',
PlaceOfBirth Varchar(32) null default '',
Nationality Varchar(32) null default '',
ClubNo integer null default '',


All the text values are varchar if that makes a difference !!

Any ideas ??