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