PostgreSQL ByteA blob fetch bug
Posted: 13.11.2006, 20:18
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
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