From: | theofilu(at)eunet(dot)at (Theofilu Andreas) |
---|---|
To: | pgsql-interfaces(at)postgresql(dot)org |
Subject: | Problem with character in strings |
Date: | 1999-09-12 19:31:44 |
Message-ID: | 199909121931.VAA07508@eunet.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
-----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-----
From | Date | Subject | |
---|---|---|---|
Next Message | Rusty Brooks | 1999-09-12 19:47:53 | Re: [INTERFACES] Problem with character in strings |
Previous Message | Tom Lane | 1999-09-12 16:01:41 | Re: [INTERFACES] ecpg and getting just assigned serial number |