Re: standard_conforming_strings and pg_escape_string()
От | Daniel Verite |
---|---|
Тема | Re: standard_conforming_strings and pg_escape_string() |
Дата | |
Msg-id | 31584b40-894d-4689-9663-ac2ed436cd89@mm обсуждение исходный текст |
Ответ на | standard_conforming_strings and pg_escape_string() (Conrad Lender <crlender@gmail.com>) |
Ответы |
Re: standard_conforming_strings and pg_escape_string()
|
Список | pgsql-general |
Conrad Lender wrote: > I would like our database abstraction to be able to handle both settings > for standard_conforming_strings transparently, i.e. perform the escaping > according to the current DB server settings. Since pg_escape_string() is > aware of the current database connection, I had expected its behavior to > change accordingly: > > no std strings: > x\y --> x\\y > with std strings: > x\y --> x\y It works for me: $ php -e <? echo phpversion(), "\n"; $c=pg_connect("dbname=mail user=daniel host=/tmp port=5000"); pg_query("SET standard_conforming_strings=off"); echo pg_escape_string('toto\titi'), "\n"; pg_query("SET standard_conforming_strings=on"); echo pg_escape_string('toto\titi'), "\n"; ?> Output: 5.2.0-8+etch13 toto\\titi toto\titi Best regards, -- Daniel PostgreSQL-powered mail user agent and storage: http://www.manitou-mail.org
В списке pgsql-general по дате отправления: