From: Michael Meskes <meskes@postgreSQL.org>
To: Theofilu Andreas <theofilu@eunet.at>
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] Still have problem with single quotation mark
Date: Tue, 14 Sep 1999 20:24:35 +0200
Message-ID: <19990914202435.C5414@gmx.net> (raw)
In-Reply-To: <199909132011.WAA07963@eunet.at>
References: <199909132011.WAA07963@eunet.at>
On Mon, Sep 13, 1999 at 10:11:53PM +0200, Theofilu Andreas wrote:
> There is still a problem with the single quotation mark (') inside a
> string, when this string is inserted into the database and one uses 'ecpg'.
> Someone on this list told me, that I should precede a ' with a second '
> (''). Then it would not be interpreted as the end of string. I did this and
> realy, now it is not interpreted at all. 'ecpg' puts now both quotation
> marks into the database table. This makes for example the words 'I don't
> want this' appear as 'I don''t want this'. Preceding the quotation mark
> with a backslash does not help also. Then I get the SQL error 'too many
> arguments in line xxx'. This is really annoying. How can I fix this?
Which version do you use? There was a quotation problem that should be solved in
the current version. Also how do you feed the date into the statement? As a
char variable or as a constant string?
Michael
--
Michael Meskes | Go SF 49ers!
Th.-Heuss-Str. 61, D-41812 Erkelenz | Go Rhein Fire!
Tel.: (+49) 2431/72651 | Use Debian GNU/Linux!
Email: Michael@Fam-Meskes.De | Use PostgreSQL!
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: meskes@postgreSQL.org, theofilu@eunet.at
Subject: Re: [INTERFACES] Still have problem with single quotation mark
In-Reply-To: <19990914202435.C5414@gmx.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox