[ psqlodbc-Bugs-1002766 ] 08.02.0205,200703150001 snapshot returns wide characters

Bugs item #1002766, was opened at 2007-03-26 11:17
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=10027 66&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.0205,200703150001 snapshot returns wide characters

Initial Comment:
To reproduce, run the following code in Microsoft Visual FoxPro 9 SP1:

cConnStr= "DRIVER={PostgreSQL Unicode};UID=admin;Password=pa;database=eeva;server=localhos t;B9=0;PROTOCOL=-0"
lnConnHandle = sqlstringconnect( cconnstr )

IF lnConnHandle <= 0
AERROR(laError)
MESSAGEBOX( laerror[1,2] )
ENDIF

TEXT TO cvr textmerge
SELECT table_name
FROM information_schema.tables
WHERE table_type = 'BASE TABLE' AND table_schema='firma1'
ORDER BY table_name
ENDTEXT

SQLEXEC( lnconnhandle, cvr )
BROWSE norm

Observed:

1. in result table space appears after every character in table name
2. column data type is Memo.


Expected:

1. table_name should contain only single characters
2. table_name column data type

Note.
08.02.0200 version of driver produces expected result.
This appears only in snapshot

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

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

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq