Problem with character in strings - Mailing list pgsql-interfaces

From theofilu@eunet.at (Theofilu Andreas)
Subject Problem with character in strings
Date
Msg-id 199909121931.VAA07508@eunet.at
Whole thread Raw
Responses Re: [INTERFACES] Problem with character in strings
List 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-----


pgsql-interfaces by date:

Previous
From: Nathan Fain
Date:
Subject: Problem with "'"
Next
From: Rusty Brooks
Date:
Subject: Re: [INTERFACES] Problem with character in strings