[solved] Delphi, Postgres - blob field, file storage
Posted: 23.05.2013, 14:58
Hello,
i looked everywhere and really didnt found answer.
I'm using postgres 9.2, Delphi 2009 and XE3 and zeos 7.0.0.3
I tried to upload file to bytea type field. When i upload it (zquery), and download without refreshing, everything is ok. Until i close and open query (load data from DB) file size is 3x times bigger. I tried different methods...from simplest LoadFromFile to working with streams. And on every method result is the same. Uploaded 10kb file got 31kb file. What i'm doing wrong?
I'm realllly sorry, if that was in some topic, i'm on this all day, and my head isnt thinking really cleary.
i looked everywhere and really didnt found answer.
I'm using postgres 9.2, Delphi 2009 and XE3 and zeos 7.0.0.3
I tried to upload file to bytea type field. When i upload it (zquery), and download without refreshing, everything is ok. Until i close and open query (load data from DB) file size is 3x times bigger. I tried different methods...from simplest LoadFromFile to working with streams. And on every method result is the same. Uploaded 10kb file got 31kb file. What i'm doing wrong?
I'm realllly sorry, if that was in some topic, i'm on this all day, and my head isnt thinking really cleary.
![[solved]](./images/smilies/tick.gif "Thread solved"){kind=small}
to your topic..