Re: BUG in Unicode Driver - was: Re: Can't get more than 255 chars out of memo field in Acc

From: Benjamin Scherrey <scherrey(at)proteus-tech(dot)com>
To: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>, Benjamin Scherrey <scherrey(at)proteus-tech(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: BUG in Unicode Driver - was: Re: Can't get more than 255 chars out of memo field in Acc
Date: 2002-11-27 22:53:23
Message-ID: DBFAWRTNMJHF74RPJB8TSUOUPKJB6.3de54ce3@BONZO
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

I take it back- I'm completely screwed:

I dunno why but the non-Unicode drivers keeps displaying #Name as the content of all
my fields. Only the Unicode driver shows my content but only the Unicode driver seems unable to
recognize the memo field correctly. This really throws my project into big problems. I don't
understand what the #Name stuff is all about. Any ideas?

Ben Scherrey

11/27/2002 5:37:30 PM, Benjamin Scherrey <scherrey(at)proteus-tech(dot)com> wrote:

>Ah Ha! I created a new DSN with PostgreSQL+(Beta) and it correctly interpreted the UR Notes as
>a memo field. Went back with another new DSN using PostgreSQL+Unicode(Beta) and it would
>not take it as a memo field. Presently I don't think the Unicode is critical for my app but I think its
>something that should be corrected if possible.
>
>Thanx VERY much for your help,
>
> Ben Scherrey
>
>11/27/2002 5:10:21 PM, "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> wrote:
>>I just tried linking this table with:
>>
>>psqlODBC 07.02.0004
>>PostgreSQL 7.3rc1/Cygwin
>>Access XP
>>
>>And it works perfectly using a DSN with all default settings:
>>
>>ID Number
>>Date Opened Date/Time
>>Name Text
>>Account# Number
>>Date of Birth Text
>>Attending MD Text
>>Health Plan Category Text
>>County Text
>>Case Status Text
>>UR Notes Memo
>>
>>Regards, Dave.

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Jeff Eckermann 2002-11-27 23:41:22 Re: Can't get more than 255 chars out of memo field in Acc
Previous Message Benjamin Scherrey 2002-11-27 22:37:30 BUG in Unicode Driver - was: Re: Can't get more than 255 chars out of memo field in Acc