Page 1 of 1

PostgreSQL ByteA blob fetch bug

Posted: 13.11.2006, 20:18
by 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

Posted: 13.11.2006, 20:21
by coppola
Sorry, I ment "... throughout the WHOLE company."

Oops! ;-)

Posted: 13.11.2006, 20:29
by coppola
I mean "I meant" :oops:
I think I'll stop before I misspell something I cannot apologize for...

Posted: 14.11.2006, 13:12
by coppola
Never mind, fellows.

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

And everything is working all right.

Thanks a lot, :lol:

Coppola.

Posted: 14.11.2006, 14:51
by 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

Posted: 17.11.2006, 11:36
by coppola
Thanks! I'll check it out.

Best regards,

Coppola.

Posted: 06.10.2007, 22:59
by 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...