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