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
