From: | JPTrue(at)aol(dot)com |
---|---|
To: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: Text-Varchar Truncation via ODBC |
Date: | 2002-09-27 14:12:25 |
Message-ID: | 1F017978.6EA06539.00048176@aol.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Thank you for the Reply,
Yes, access has the TEXT and MEMO data types.
The TEXT data type in Access is limited to 255 characters.
My problem was trying to map any PostGreSQL datatype to the Access-MEMO datatype. Access maps all variations of PostGreSQL-VARCHAR(n) to Access-TEXT.
I finally found a solution.
1. Make sure to select the 'Text As LongVarchar' option in the PostGreSQL ODBC Driver.
2. The PostGreSQL-TEXT datatype will map to Acess-MEMO datatype (DTS as well).
***(HINT) Using the linked table manager in Access to update modified tables does not work well. If any changes are made to a linked PostGreSQL table, the linked table in Access must be deleted and recreated to update the changes.
Thanks to everyone for your replies, and hopefully this note will help someone in the future.
Jeff
From | Date | Subject | |
---|---|---|---|
Next Message | Joe Conway | 2002-09-27 16:53:02 | Re: [ODBC] [s.hetze@linux-ag.de: PostgreSQL integration Visual Basic, |
Previous Message | Hiroshi Inoue | 2002-09-26 23:49:29 | Re: Delphi / ODBC / DataSet.RecordCount failed on 7.2.2 |