| From: | Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp> |
|---|---|
| To: | JPTrue(at)aol(dot)com |
| Cc: | pgsql-odbc(at)postgresql(dot)org |
| Subject: | Re: Text-Varchar Truncation via ODBC |
| Date: | 2002-09-26 23:48:10 |
| Message-ID: | 3D939CBA.8A20C066@tpf.co.jp |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
JPTrue(at)aol(dot)com wrote:
>
> Hello,
> I am using a variety of programs to attach to a PostGreSQL
> database via ODBC, including MS Access 2000 and MS DTS 7.0.
>
> Any column in my PostGreSQL database with a datatype of TEXT
> of VARCHAR(n) is limiting/truncating INSERTed or UPDATEd data
> to ~255 characters.
> I have tested and tried all variations of TEXT and VARCHAR(n)
> in my PostGreSQL database.
> In addition, I have tried modifying all settings in the ODBC
> driver ( I am using version 7.02.00.02).
Did you try to turn on *Text As LongVarchar* option ?
regards,
Hiroshi Inoue
http://w2422.nsk.ne.jp/~inoue/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hiroshi Inoue | 2002-09-26 23:49:29 | Re: Delphi / ODBC / DataSet.RecordCount failed on 7.2.2 |
| Previous Message | Peter Staudt | 2002-09-26 13:30:10 | Text-Varchar Truncation via ODBC |