| From: | "Ing(dot) Ivo Schwarzer" <schwarzer(at)bugnion(dot)it> |
|---|---|
| To: | pgsql-odbc(at)postgresql(dot)org |
| Subject: | TEXT fields with size > 8190 |
| Date: | 2001-05-18 08:17:57 |
| Message-ID: | 3B04F6D5.7702.2FD1F8@localhost |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
Why am I unable to store long strings using TEXT fields if the size
of my string is > 8190 chars?
If I try to increase Max LongVarChar to 20000 (in the Advanced
Options box of the Odbc driver) i get run-time error -2147467259
(80004005) in my VisualBasic 6 application (Ado 2.5).
I use Postgres 7.1.1 (RedHat 6.2 RPM version) and the win ODBC
driver 7.01.00.05 (in the Data Type Option box I have Text as
longVarChar = true).
Is this a Driver related error or am I wrong trying to use a TEXT field
to store long strings (< 64k)?
Thanks, Ivo.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jorge Santos | 2001-05-18 20:50:22 | Postgresql 7.1 + unixODBC 2.0.5 + StarOffice 5.2 |
| Previous Message | Peter Wilkinson | 2001-05-17 12:45:09 | Are there any special gotcha's with using cursors with ODBC to postgresql? |