Date: Tue, 14 Sep 1999 20:24:35 +0200
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
Message-ID: <19990914202435.C5414@gmx.net>
Mail-Followup-To: Theofilu Andreas <theofilu@eunet.at>,
	pgsql-interfaces@postgresql.org
References: <199909132011.WAA07963@eunet.at>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
In-Reply-To: <199909132011.WAA07963@eunet.at>;
	from Theofilu Andreas on Mon, Sep 13, 1999 at 10:11:53PM +0200

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!