Problems Escaping quotes by backslash with PsqlODBC

Поиск
Список
Период
Сортировка
От Walter, Gregor
Тема Problems Escaping quotes by backslash with PsqlODBC
Дата
Msg-id F7DE1390D677D2118EFB0008C7A4335023A9C1@DESDC01
обсуждение исходный текст
Список pgsql-interfaces
hi,

I am using the pgadmin windows tool with the latest PsqlODBC drivers.
The problem seems to be, that running a query with escaped quotes like
[Select * from test where xyz like 'pete\'s cafe'] doesnt work, but
using 2 single quotes works: [Select * from test where xyz like 'pete''s
cafe'].
But I can run both queries on the psql command line interface on linux.

Can this be a problem with the ODBC or is there a setting that can be
changed to also allow both ways?

thanks,
Gregor Walter
GW@Globalfulfillment.com


В списке pgsql-interfaces по дате отправления:

Предыдущее
От: Byron Nikolaidis
Дата:
Сообщение: Re: query from Murty
Следующее
От: Peter Mount
Дата:
Сообщение: RE: ODBC and crypted passwords