Skip site navigation (1) Skip section navigation (2)

Re: Values in the select

From: "Campbell, Greg" <greg(dot)campbell(at)us(dot)michelin(dot)com>
To: "A(dot)j(dot) Langereis" <a(dot)j(dot)langereis(at)inter(dot)nl(dot)net>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Values in the select
Date: 2005-12-24 04:05:45
Message-ID: 43ACC919.6080609@us.michelin.com (view raw or flat)
Thread:
Lists: pgsql-odbc
Nice sample.
Perhaps you can use a DSN connection and in the PostgreSQL ODBC Driver setup for the connection turn on 
mylog.
Or you can use the ODBC Administrator, under the tracing tab, Start Tracing.
Or in the server postgresql.conf temporarily turn the logging on for all statements, to capture lower 
level ODBC communication.

Do the ODBC connection encoding, and the database encoding match?

A.j. Langereis wrote:
> 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

Attachment: greg.campbell.vcf
Description: text/x-vcard (241 bytes)

In response to

pgsql-odbc by date

Next:From: Ludek FinstrleDate: 2005-12-24 09:35:43
Subject: patch for [ psqlodbc-Bugs-1000498 ] rollback to savepoint in case of error
Previous:From: Campbell, GregDate: 2005-12-24 00:22:28
Subject: Re: ODBC connection string, MS Access

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group