Обсуждение: problem with _ character

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

Pierre Couderc wrote:
> I am using ANSI odbc driver

How exactly?  Are you calling the ODBC API directly in C(++), or are
you using some DB driver from some other language?


Regards,
Clemens

On 2/20/19 1:44 PM, Clemens Ladisch wrote:
> Pierre Couderc wrote:
>> I am using ANSI odbc driver
> How exactly?  Are you calling the ODBC API directly in C(++), or are
> you using some DB driver from some other language?
>
>
the ODBC API from cpp.

Thank you.

PC

On 2/20/19 1:44 PM, Clemens Ladisch wrote:
> Pierre Couderc wrote:
>> I am using ANSI odbc driver
> How exactly?  Are you calling the ODBC API directly in C(++), or are
> you using some DB driver from some other language?
>
>
the ODBC API from cpp.

It works since years with othe DBs.


Thank you.

PC

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

On 2/20/19 3:47 PM, Christophe Garault wrote:
> Hi Pierre,
>
> Place your identifiers between double quotes...

It is not an identifier, it is data, it is the content of a field !

On 2/20/19 11:42 AM, Pierre Couderc wrote:
>
> Thanks.
>
It is my mistake, sorry for the noise...