# Apostophe error

**URL:** <https://www.ruby-forum.com/t/apostophe-error/107118>\
**Category:** Rails\
**Created:** [June 18, 2007, 12:02pm UTC](https://www.ruby-forum.com/t/apostophe-error/107118 "2007-06-18T12:02:33Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![farfignugen](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/f/f17d59/32.png) [@farfignugen](https://www.ruby-forum.com/u/farfignugen)\
**Post date:** [June 18, 2007, 12:02pm UTC](https://www.ruby-forum.com/t/apostophe-error/107118/1 "2007-06-18T12:02:33Z")

</div>

Hello,

I received the following error when updating a field in an  
activerecord which contains an apostrophe “’”

ActiveRecord::StatementInvalid (DBI::DatabaseError: Execute  
OLE error code:80040E14 in Microsoft OLE DB Provider for SQL  
Server  
Öffnendes Anführungszeichen vor der Zeichenfolge  
‘70dea99f72a57e4c3c0e35079cd9a4e1de03b4df WHERE [ID] = 957’.

This is primaly caused by a field which contains: “Hugo’s housewifes”

Anbyody out there who can give me a tip?

Thanks!  
Chris