[ psqlodbc-Bugs-1010500 ] UUID not being returned correctly

Bugs item #1010500, was opened at 2008-10-28 14:09
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=10105 00&group_id=1000125

Category: None
Group: None
Status: Open
Resolution: None
Priority: 3
Submitted By: Philip Warner (pjw)
Assigned to: Nobody (None)
Summary: UUID not being returned correctly

Initial Comment:

I have the following in a postgres 8.3 DB:

Create Table test(f uuid);
insert into test values('e964684f-87fe-49d9-9b87-137cc83165ea');

I have the following VB.Net 2005 code that connects to this DB (using either ANSI or UNICODE driver); full connection string below. I use a DataAdapter as follows:

Dim c As New ODBC.ODBCConnection(My.Settings.ConnectionString)
Dim DA As New Odbc.OdbcDataAdapter("select f::text, f from test", c)
Dim Tbl As New DataTable
DA.Fill(zTbl)

When I inspect the values, they differ:

?tbl.Rows(0).Item(0).ToString
"e964684f-87fe-49d9-9b87-137cc83165ea"
?tbl.Rows(0).Item(1).ToString
"00390065-0036-0034-3600-380034006600"

The original can be stored using the ODBC driver, it just seems to have trouble retrieving it.



Full connection string:

Driver={PostgreSQL ANSI};database=time_log;server=xxx.yyy.zzz.ttt;port=5433;uid =root;sslmode=allow;readonly=0;protocol=7.4-1;fakeoidindex=0 ;showoidcolumn=0;rowversioning=0;showsystemtables=0;fetch=10 0;socket=4096;unknownsizes=0;maxvarcharsize=255;maxlongvarch arsize=8190;debug=0;commlog=0;optimizer=0;ksqo=1;usedeclaref etch=0;textaslongvarchar=1;unknownsaslongvarchar=0;boolsasch ar=0;parse=0;cancelasfreestmt=0;extrasystableprefixes=dd_;lf conversion=1;updatablecursors=0;disallowpremature=0;trueismi nus1=1;bi=0;byteaaslongvarbinary=0;useserversideprepare=0;lo wercaseidentifier=0;xaopt=1



------------------------------------------------------------ ----------

>Comment By: Hiroshi Inoue (hinoue)
Date: 2008-10-31 22:04

Message:
Could you try the drivers on testing for 8.3.0300 dll at
http://www.geocities.jp/inocchichichi/psqlodbc/index.html
?

------------------------------------------------------------ ----------

You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=10105 00&group_id=1000125

--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc