SQL escape

I’m trying to insert a row that looks like this:

INSERT INTO country VALUES (‘CI’,‘COTE D’IVOIRE’,‘Cote D’Ivoire’,‘CIV’,‘384’);

but no matter what I try it keeps spitting an error at me. How would I get sql to realize that I’m trying to escape to insert the ’ .