Apostrophes et al in a files with text attribute

From: The Web Administrator <wwwadmin(at)wizard(dot)ca>
To: PostGres General Questions <pgsql-general(at)postgresql(dot)org>
Subject: Apostrophes et al in a files with text attribute
Date: 1998-05-15 13:08:56
Message-ID: 355C3E68.BB141A44@wizard.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have passed text via a Perl CGI to my database, and tried storing text

into a field with the text attribute. Only problem is if there is an
apostrophe in the string as in the word "can't"
it will not INSERT.... hmm... isn't "isn't" text?

hehehe.. anyways, what is the usual work around?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message The Hermit Hacker 1998-05-15 13:51:45 Re: [GENERAL] Apostrophes et al in a files with text attribute
Previous Message Yonny Cardenas Baron 1998-05-15 09:35:03 Distributed Database with PostgreSQL