Single quotes seem to not be allowed in posts

My site, Breakfastclubber.com/42 , looks ok from the main page, but I haven’t been able to post entries with single quotes. when I post an entry without single quotes

this is a post to see if single quotes are killing the ability to post.

it works, but making the entry

this is a post to see if a post’s single quotes are killing the ability to post.

I get this

WordPress database error: [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 ‘s single quotes are killing the ability to post.’, ‘Testing ide]
INSERT INTO fortytwo_posts (ID, post_author, post_date, post_date_gmt, post_content, post_title, post_excerpt, post_status, comment_status, ping_status, post_password, post_name, to_ping, post_modified, post_modified_gmt, post_parent, menu_order) VALUES (’29’, ‘1’, ‘2005-04-20 19:56:28’, ‘2005-04-21 00:56:28’, ‘this is a post to see if a post’s single quotes are killing the ability to post.’, ‘Testing idea about single quotes breaking post’, ”, ‘publish’, ‘open’, ‘open’, ”, ‘testing-idea-about-single-quotes-breaking-post-2’, ”, ‘2005-04-20 19:56:28’, ‘2005-04-21 00:56:28’, ‘0’, ‘0’)

Warning: Cannot modify header information – headers already sent by (output started at /homepages/41/d89530764/htdocs/root_becca/42/wp-includes/wp-db.php:98) in /homepages/41/d89530764/htdocs/root_becca/42/wp-admin/post.php on line 153

Warning: Invalid argument supplied for foreach() in /homepages/41/d89530764/htdocs/root_becca/42/wp-admin/post.php on line 158

it seems to cut right before the single quote, and after one later in the post. any suggestions on what I could do? now I’m just not using single quotes, but in the future it would be a good thing to be able to do.