Thread: 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...