[ psqlodbc-Bugs-1010500 ] UUID not being returned correctly
От | |
---|---|
Тема | [ psqlodbc-Bugs-1010500 ] UUID not being returned correctly |
Дата | |
Msg-id | 20120322234843.DEA9015C9C09@pgfoundry.org обсуждение исходный текст |
Список | pgsql-odbc |
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 stringbelow. 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=100;socket=4096;unknownsizes=0;maxvarcharsize=255;maxlongvarcharsize=8190;debug=0;commlog=0;optimizer=0;ksqo=1;usedeclarefetch=0;textaslongvarchar=1;unknownsaslongvarchar=0;boolsaschar=0;parse=0;cancelasfreestmt=0;extrasystableprefixes=dd_;lfconversion=1;updatablecursors=0;disallowpremature=0;trueisminus1=1;bi=0;byteaaslongvarbinary=0;useserversideprepare=0;lowercaseidentifier=0;xaopt=1 ---------------------------------------------------------------------- >Comment By: Hiroshi Inoue (hinoue) Date: 2012-03-22 23:48 Message: Hi Nicolas, I cannot reproduce the case with MS Access 2002. Could you attach the Mylog output of your case? regards, Hiroshi Inoue ---------------------------------------------------------------------- Comment By: Nicolas Helleringer (nhe) Date: 2012-03-20 15:26 Message: Done the same on a x86 32 bits host / Access / ODBC driver Same results, GUID are not well transfered. ---------------------------------------------------------------------- Comment By: Nicolas Helleringer (nhe) Date: 2012-03-20 14:10 Message: Same bug here with the x64 latest driver version (2011-12-30 version) Context : - From MS Access 2010 64 bits - Replication number field GUID - Export table to ODBC tool With the unicode driver the tables are created correctly i-e fields are mapped to uuid fields (with ansi version they aremapped to bytea fields) but data in them is not ok. Source is GUID like : {7AB02082-2242-4A65-A7E3-6B624BF4873E} Transfered data is like : 00410037-0042-0030-3200-300038003200 ---------------------------------------------------------------------- Comment By: Philip Warner (pjw) Date: 2008-11-01 12:14 Message: Thanks for the quick response! I tried the ASCII driver, and it worked, which is great! How stable are the beta drivers? and/or any schedule for releasing a production version? Thanks again. ---------------------------------------------------------------------- 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=1010500&group_id=1000125
В списке pgsql-odbc по дате отправления: