| From: | markh(at)clockworkweb(dot)com (Mark Himsley) |
|---|---|
| To: | pgsql-interfaces(at)postgresql(dot)org |
| Subject: | varchar() access |
| Date: | 1999-01-26 23:33:04 |
| Message-ID: | 36af4d47.5005609@jupiter.clockworkweb.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-interfaces |
I'm accessing a postgres 6.3 server on Linux 2.0.35 using the 6.40.0004
ODBC driver on NT 4S.
I am having a problem with varchar columns being truncated to 4K bytes
when coming from the backend, although I can store > 4K into the
backend.
I have set max LongVarChar to 7000 and -4 (as suggested in the FAQ)
I have tried checking and not checking the 'text as LongVarChar' box.
I have seen the problem in Access 97 and ColdFusion 4 on 2 separate
servers.
I'm I doing something wrong, have I got the wrong end of a stick, or do
I have to use large objects...
Thanks, in advance, for any help.
--
Mark Himsley.
Technical Director,
Clockwork Web.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | hgati | 1999-01-27 01:57:11 | subscribe pgsql-admin |
| Previous Message | rob | 1999-01-26 22:30:00 | Re: pgsql-interfaces-digest V1 #206 |