Thread: [ psqlodbc-Bugs-1009413 ] 08.02.0500 SELECT * returns double with for CHAR columns
Bugs item #1009413, was opened at 2007-10-09 19:04 You can respond by visiting: http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1009413&group_id=1000125 Category: None Group: None Status: Open Resolution: None Priority: 3 Submitted By: Andrus Moor (kobruleht) Assigned to: Nobody (None) Summary: 08.02.0500 SELECT * returns double with for CHAR columns Initial Comment: To reproduce: 1. Create table desktop in database containing column baas char(8) 2. Install 08.02.0500 version of odbc driver in Windows XP 3. Run the following code in Microsoft Visual FoxPro 9 SP1 : cConnStr= "DRIVER={PostgreSQL Unicode};UID=postgres;Password=a;database=eeva;server=localhost;B9=0" lnConnHandle = sqlstringconnect( cconnstr ) TEXT TO cvr textmerge SELECT * FROM desktop limit 0 ENDTEXT SQLEXEC( lnconnhandle, cvr ) SELECT sqlresult BROWSE norm Observed: Column baas width is 16 characters Expected: Column baas width is 8 characters Notes: 1. SELECT baas FROM desktop LIMIT 0 returns correct column width (8 characters) 2. Previous drivers version (0200) works OK. Log included. ---------------------------------------------------------------------- >Comment By: Hiroshi Inoue (hinoue) Date: 2007-10-11 06:02 Message: Could you try the the drivers on testing for 8.2.0501 at http://www.geocities.jp/inocchichichi/psqlodbc/ ? ---------------------------------------------------------------------- You can respond by visiting: http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1009413&group_id=1000125