Values in the select

Dear all,

 

I have written an application that uses Postgresql (8.1.0) trough an ODBC (ANSI) connection. I noticed that a query like "select 'bar' as foo" does not give the value "bar" in the column "foo". This works normally under PGadmin and even on other databases via ODBC. Am I overlooking something or might this be a bug?

 

Values that I do get are like "#0#0#0#0#0"

 

A piece of Delphi code to show the problem:

 

procedure show_problem(conn : TADOConnection)

var

    qry : TAdoQuery;

    datasource: TDataSource;

begin

    qry := TADOQuery.create(nil);

    qry.Connection:=conn;

    qry.SQL.Text:= 'select ''bar'' as foo';

   

    qry.Open;

 

    if not qry.eof then

        begin

        datasource := TDataSource.Create(nil);

        datasource.dataset := qry;

 

        //datasource.DataSet.Fields[1].AsString now has the value of '#0#0#0#0#0'

        //datasource.DataSet.Fields[1].FieldName is now equal to 'foo'

 

        datasource.free;

        end;

 

    qry.close;

    qry.free;

end;

 

The version of ODBC that I've got installed is 08.00.0102 (via MSI installed).

 

Yours,

 

Aarjan