problem with _ character

From: Pierre Couderc <pierre(at)couderc(dot)eu>
To: pgsql-odbc(at)postgresql(dot)org
Subject: problem with _ character
Date: 2019-02-20 10:42:50
Message-ID: 9f7bc2b3-83df-e2c5-cdd9-3164afdddfb6@couderc.eu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hello,

I am using ANSI odbc driver (11.0) on a W10  with a utf8 DB trying to :

SELECT * FROM table WHERE (name = ?);

with a name including a '_' character : '1170332_381-P364'

In the postgresql server logs, I see that it has been replaced with
'1170332[_]381-P364' and my query fails.

How should I do ?

Thanks.

PC

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Clemens Ladisch 2019-02-20 12:44:06 Re: problem with _ character
Previous Message Clemens Ladisch 2019-02-09 07:57:18 Re: Reported lengths of char fields - psqlODBC