Skip site navigation (1) Skip section navigation (2)

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

From: <noreply(at)pgfoundry(dot)org>
To: noreply(at)pgfoundry(dot)org
Subject: [ psqlodbc-Bugs-1002766 ] 08.02.0205,200703150001 snapshot returns wide characters
Date: 2007-04-05 19:46:04
Message-ID: 20070405194604.AE31521756C@pgfoundry.org (view raw or flat)
Thread:
Lists: pgsql-odbc
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

pgsql-odbc by date

Next:From: noreplyDate: 2007-04-05 19:51:51
Subject: [ psqlodbc-Bugs-1002827 ] ODBC logging not working in Windows Vista with UAC on
Previous:From: noreplyDate: 2007-04-05 19:43:14
Subject: [ psqlodbc-Bugs-1002767 ] Fatal exception error after running some queries

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group