Re: problem with _ character

Christophe Garault <[email protected]> Wed, 20 Feb 2019 15:47:25 +0100

Newsgroups	gmane.comp.db.postgresql.odbc
Message-ID	<[email protected]>

Hi Pierre,

Place your identifiers between double quotes:
https://www.postgresql.org/docs/9.1/sql-syntax-lexical.html

hth.


Le 20/02/2019 11:42, Pierre Couderc a écrit :
> 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