Blob handling with Delphi... - Mailing list pgsql-general

From Durumdara
Subject Blob handling with Delphi...
Date
Msg-id BANLkTin776CXDi213q0HDhLf59z13iXFJA@mail.gmail.com
Whole thread Raw
Responses Re: Blob handling with Delphi...
List 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

pgsql-general by date:

Previous
From: "Henry C."
Date:
Subject: Re: Trying out replication: cp cannot stat log file during recovery
Next
From: John R Pierce
Date:
Subject: Re: Blob handling with Delphi...