From: theofilu@eunet.at
To: pgsql-interfaces@postgresql.org
Subject: Problem with character in strings
Date: Sun, 12 Sep 1999 21:31:44 +0200 (MEST)
Message-ID: <199909121931.VAA07508@eunet.at> (raw)
-----BEGIN PGP SIGNED MESSAGE-----
Hi to all,
As explained in a previous mail today, I'm porting an Informix based
application to PostgreSQL. Now this work is nearly done, but there is
still a problem with the character ' in strings. I'm using 'ecpg' for
develop. Whenever a ' appears in a string that should be inserted into the
database, it crashes with the error 'too many arguments in line'. I found
out that the ' is interpreted as 'end of string'. How's that possible? I'm
using normal variables in the application. Is there a workaround possible?
However. I know I can precede every ' with a backslash, but that would make
my code completely incompatible to the still supported Informix. Can I
change the delimiter for strings in some way?
Some data:
PostgreSQL 6.5.1
Linux 2.2.7 (SuSE 6.1)
Intel Pentium
egcs-2.91.66
- --
Theofilu Andreas
http://members.eunet.at/theofilu
-------------------------------------------------
Enjoy the science of Linux!
Genieße die Wissenschaft von Linux!
-------------------------------------------------
-----BEGIN PGP SIGNATURE-----
Version: 2.6.3i
Charset: latin1
iQCVAwUBN9v/pmj/BcrYxhjVAQE11gP/VJaJh+8e6Y+2c666Rswg6B5htbujsMOU
oYJotlP2w6u7gr81m2sG14FM4pq0KfhvKXj9HQ9Fr4O6GXz4/Bf4xZ4jwBPWK3NZ
1Ml3ffTAadGLFsol9cN32ERRv35pW11snPeVBOZ9orxULle1TLNHzvwZfEJbhk+q
MmmhdRqsPbA=
=r23y
-----END PGP SIGNATURE-----
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: theofilu@eunet.at
Subject: Re: Problem with character in strings
In-Reply-To: <199909121931.VAA07508@eunet.at>
* 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