Re: Load Image File From PostgreSQL DB

Hi2 Julius,

Thanks for your reply, present i using oid data type for store image file, and good working without problem too if i open and showing with PHP, but i'm verry dificulty to showing the image file using delphi 7.

also i'm not using third party like ODBC but i'm directly connected to PostgreSQL Database using Zeos Component.

Any sugestion for me bro ?

many thanks and regards,

dbalinglung

>----- Original Message -----
>From: "Julius Tuskenis" <julius(dot)tuskenis(at)gmail(dot)com>
>Cc: <pgsql-general(at)postgresql(dot)org>
>Sent: Tuesday, December 30, 2008 2:46 PM
>Subject: Re: [GENERAL] Load Image File From PostgreSQL DB
>

> Hi, dbalinglung.
>
> You are probably confusing types oid and lo or bytea. There's no way you
> could put a image into oid column. I'm using bytea type without problems.
> Also check "bytea as lo" checkbox in ODBC dialog (if you use ODBC). Also
> TDBImage is no good if you want to use jpg files. I found an alternative
> - EDBImage.
>
> Hope that helps. Good luck.
>
> Julius Tuskenis
>
>