PostgreSQL ByteA blob fetch bug

[coppola]

Hi folks,

I'm experiencing some strange behavior with ByteA blob fields.
I have an application that needs to store Dlls in a DB as a central
repository so they can be used throughout the hole company.
I have no problem putting the Dlls in the DB (tested with SQL Manager
2005 Lite for PostgreSQL v3.4.0.4 from EMS Database Management
Solutions, Inc) but when I fetch them through ZEOS they return corrupted.
I tested it using a large text file (720kb) and found out that the character '\'
is been treated as an escape sequence of some sort what causes the next
three characters to be reinterpreted. Since the file's content is binary you
can imagine the chaos that arises from this.

I'm using ZEOS 6.5.1 alpha CVS as of 13/10/2005 with PostgreSQL 8.1.4
and Delphi 7.1 (WinXP Professional SP2).

TIA,

Coppola

[coppola]

Sorry, I ment "... throughout the WHOLE company."

Oops!

[coppola]

I mean "I meant"
I think I'll stop before I misspell something I cannot apologize for...

[coppola]

Never mind, fellows.

I've downloaded the last revision:
- ZEOS_TESTING_REV_113.7z

And everything is working all right.

Thanks a lot,

Coppola.

[mdaems]

Hey... I think you missed our beta release... See Portal page of this forum. This beta includes all of Rev 113 (and a little more).

Mark

[coppola]

Thanks! I'll check it out.

Best regards,

Coppola.

[everdaniel]

hi coppola

how do you manage to insert binary files in your postgresql with Delphi and Zeos? I try to do the same with no results, is there any tutorial or help that you read to do that? I try to store the files (images) in a bytea field with no results (I definitely do something wrong)

I will really apreciate if you can give me some help....

Thanks in advance...