8.2 and nonstandard use of \\ in prepared statements
| От | Stefano B. |
|---|---|
| Тема | 8.2 and nonstandard use of \\ in prepared statements |
| Дата | |
| Msg-id | 03a101c7201f$6396a300$0501a8c0@comai04 обсуждение исходный текст |
| Ответы |
Re: 8.2 and nonstandard use of \\ in prepared statements
|
| Список | pgsql-jdbc |
Hi,
I have installed postgresql 8.2 and I get some warning messages about use of backslashes in my queries.
I have a query like:
insert into mytable (f1,f2,f3) values (?,?,?)
where f3 is a binary stream
when the query is executed the server returns a warning about the use of backslashes in the query:
postgresWARNING: nonstandard use of \\ in a string literal at character 96
2006-12-15 08:17:17 CET [local] dms postgresHINT: Use the escape string syntax for backslashes, e.g., E'\\'.
2006-12-15 08:17:17 CET [local] dms postgresLOG: statement: insert into synch_list (s_name,s_client,s_data) values ('20061215083000_cast,'casteggio','PK\\003\\004\\024\\000\\010\\000\\010\\000\\315C\\2175\\000\\000\\000\\...................')
2006-12-15 08:17:17 CET [local] dms postgresHINT: Use the escape string syntax for backslashes, e.g., E'\\'.
2006-12-15 08:17:17 CET [local] dms postgresLOG: statement: insert into synch_list (s_name,s_client,s_data) values ('20061215083000_cast,'casteggio','PK\\003\\004\\024\\000\\010\\000\\010\\000\\315C\\2175\\000\\000\\000\\...................')
I have tryed to use the new escape sintax:
insert into mytable (f1,f2,f3) values (?,?,(E?))
but it seems that the jdbc driver doesn't care about my new query and sends the query without the new escape syntax.
Is it possible to escape binary streams with the new escape sintax?
Thanks in advance.
Stefano
В списке pgsql-jdbc по дате отправления: