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\\...................')
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