| From: | Durumdara <durumdara(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Blob handling with Delphi... |
| Date: | 2011-04-13 08:28:03 |
| Message-ID: | BANLkTin776CXDi213q0HDhLf59z13iXFJA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi!
PG9.0, Delphi 6, Zeos.
I want to use PGSQL bytea field as normal BLOB field in Delphi.
But when I insert a value into this field, for example all characters (chr
0..255), and I fetch, and save it as blob stream into a file, I got
interesting result, not what I stored here previously.
It is got \x prefix, and it is stored hexadecimal values.
Is it normal, and I needs to convert this format to readable before I use
it, or I can get same result as in other databases/adapters (the stream
saved BlobField.SaveToFile have equal content as BlobField.LoadFromFile)...
Many DBAware components can show the blob directly as Image. With PG's \x
prefix this won't working well... :-(
Thanks for your help:
dd
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John R Pierce | 2011-04-13 08:42:04 | Re: Blob handling with Delphi... |
| Previous Message | Henry C. | 2011-04-13 08:18:27 | Re: Trying out replication: cp cannot stat log file during recovery |