- Nov 12, 2010 7:46:16 AM (6 years ago)
- 1 edited
r6035 r6171 11 11 <answer> 12 12 <para>In PostgreSQL 9.0+, the default encoding for bytea data has been changed to hex and older JDBC drivers still assume escape format. This has affected some applications 13 such as Java applications using older JDBC drivers 13 such as Java applications using older JDBC drivers 14 14 that expect the old behavior of ST_AsBinary. There are two approaches to getting this to work again.</para> 15 15 16 16 <para>You can upgrade your JDBC driver to the latest PostgreSQL 9.0 version which you can get from 17 17 <ulink url="http://jdbc.postgresql.org/download.html">http://jdbc.postgresql.org/download.html</ulink></para> 18 19 20 21 18 22 <para>If upgrading your PostgreSQL driver is not an option, then you can set the default back to the old behavior with the following change:</para> 19 23 <programlisting>ALTER DATABASE mypostgisdb SET bytea_output='escape';</programlisting>
Note: See TracChangeset for help on using the changeset viewer.