[lazarus] problems with SQLdb components and Postgres

[Zlatko Matić]

I have big problem with displaying results from a query, by using Postgres 8.1.X, TPQConnection, TSQLQuery and TSQLTransaction. I think that something is very wrong with SqlDB components...Values in some columns are not displayed at all, or are displayed incorrectly (zero insted of actual numerical value, the same datetime in all timestamp fields etc., empty cells in some varchar columns etc.). I tried with different queries and it is always the same: values in some columns are displayed correctly, while other columns are empty or with wrong values. It is not related to field's type, because some fields are correctly displayed while others are not, although having the same type. I tested also on the other computer and there was the same result. Win XP SP2, PostgreSQL 8.1.2 and PostgreSQL 8.1.4; encoding: WIN1250, recent Lazarus snapshots, as well as with current official Windows binary. Just for record, all the queries are previously tested on pgAdmin and MS Access front-end and are working without any problems on those platforms...   Do you have any idea?   P.S. Is there anybody successfully using Lazarus with Postgres 8.1.X ? I would really like to know if it is possible to use Lazarus seriously with Postgres...   Zlatko