# SQL escape

**URL:** https://forum.kirupa.com/t/sql-escape/237935
**Category:** programming
**Created:** [September 5, 2007, 4:49pm UTC](https://forum.kirupa.com/t/sql-escape/237935 "2007-09-05T16:49:55Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![bardic](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/bardic/32/3708_2.png) [@bardic](https://forum.kirupa.com/u/bardic)
#### Post date: [September 5, 2007, 4:49pm UTC](https://forum.kirupa.com/t/sql-escape/237935/1 "2007-09-05T16:49:55Z")

</div>

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 ’ .