[ 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=1002766&group_id=1000125

Category: None
Group: None
>Status: Closed
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=localhost;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

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

>Comment By: Andrus Moor (kobruleht)
Date: 2007-04-05 19:46

Message:
Yes, I expected to get ANSI characters, but VFP returns
second byte before every character.
I need to get wide Text fields also so I cannot use Max
Varchar Size.

I cannot reproduce this any more. So marking it closed.

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

Comment By: Hiroshi Inoue (hinoue)
Date: 2007-03-27 00:18

Message:
> 1. in result table space appears after every character
in table name

Do you expect to get ANSI characters but get UNICODE
ones ?

> 2. column data type is Memo.

Could you try to set Max Varchar Size to 254 ?
You can do it by adding B0=254 to your connection
string.

regards,
Hiroshi Inoue

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

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