noreply | 27 Mar 2012 15:41

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

Bugs item #1010500, was opened at 28/10/2008 15:09
You can respond by visiting: 
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1010500&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:

(Continue reading)

noreply | 28 Mar 2012 05:28

[ 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=1010500&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:

(Continue reading)


Gmane