postgresql, odbc and escape characters?

From: Kristian Rink <krink(at)pm-planc(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: postgresql, odbc and escape characters?
Date: 2004-08-27 06:31:50
Message-ID: 20040827083150.3db7e601@node428
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hello everyone...

... currently I am dealing with migrating the (unfortunately highly
proprietary) document management software we are running here from
MS Windows NT Server 4.0 to some more reliable environment. This
software relies on a file system to actually store the documents it
handles as well as on a database to keep them sorted. Right now, I
am trying to get postgresql set up as the database backend for this
software using the win32/odbc driver, but certain parts of the dms
application reproducibly fail with errors like:

DbException in SQL statement:
SELECT A_.id, A_.name, A_.description, A_.remark
FROM OrgRight A_
WHERE ((A_.description LIKE '%^%' escape '\'))
ORDER BY A_.description
Errornumber: 7
Errorstate: DbError
DbException in database
172-DSN=bf381;DATABASE=bf381;SERVER=192.168.1.170;PORT=5432;A6=;A7=
100;A8=4096;B0=254;B1=8190;BI=0;C2=dd_;;CX=1b1055dab[Thu Aug 26
14:06:15 2004] DbException: FEHLER: Fehler »unterminated quoted
string« bei »'\')) ORDER BY A_.description« bei Zeichen 158 [S1000]

For what I understood (and what sounds logical to me, looking at
those things are handled in unix environments), the \' in "escape
'\'" is parsed as an escaped ' char, so in the end the query fails
because of a missing string termination.

Question: Is there any way to modify the behavior of postgresql
server itself or of the odbc driver to deal with things like that? I
am sorry if this all sounds a little vague, but I am still trying to
figure out where to tweak, here, so hope anyone can give me a slight
clue...

TIA and bye
Kris

--
Kristian Rink -- Programmierung/Systembetreuung
planConnect GmbH * Strehlener Str. 12 - 14 * 01069 Dresden
0176 24472771 * krink(at)pm-planc(dot)de

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2004-08-27 07:44:59 Re: postgresql, odbc and escape characters?
Previous Message Greg Stark 2004-08-27 06:10:15 Re: performance of IN (subquery)