binary insert with JDBC
binary insert with JDBC
От:
Sean Reilly <sreilly@cnri.Reston.Va.US>
Дата:
Can anyone tell me how to insert binary data into a postgres table using JDBC? What type field should I use? Most importantly, how do I create an SQL statement with binary data? I thought this could be done with a PreparedStatement and setBytes() but it doesn't seem to be implemented in postgres.PreparedStatement. Is there some way to encode the binary value into the SQL string (like hex encoding or something)? I looked through the docs but couldn't find anything related to this, but it seems like it might be a common problem. Thanks, Sean