[GENERAL] binary data ...

[Gabriel López Millán]

Hello all.

I'm developer in Java with JDBC2.0.
How can I stora a binary (byte []) (such a certificate X.509,
request of certificate, etc).

 Can I use the Type  String (I think that not)?
  Should I use LOB?

Thanks a lot. Gabi.

[GENERAL] binary data LOBs

[Alex Pilosov]

Hi,

Am I correct in impression that the only way you can store binary data
(meaning data that could have all control characters including \0 in it)
is using Large Objects interface? I have tried bytea and text, both
truncate string on receipt of \0...

Also, what's physical storage size of a LOB? Does it always occupy entire
page? Or they are bunched together in rows?

I'm storing mostly small (4096 bytes) strings but they are all binary.
I'd like to know what's the best way to do that.

Thanks
-alex

[GENERAL] Binary data?

[Dirk Lutzebaeck]

Hi,

can Postgres store binary data in TEXT fields? Or is there a solution
except large objects?

Dirk