| From: | "Josh Berkus" <josh(at)agliodbs(dot)com> |
|---|---|
| To: | Le Hibou <le(dot)hibou(at)wanadoo(dot)fr>, pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Problem with varchar |
| Date: | 2002-10-13 22:19:54 |
| Message-ID: | web-1785314@davinci.ethosmedia.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Le,
> I use a varchar(400) field... but when i read it, i have not the
> complete value (but +/- 255 chars)...
>
> how can i do to have my complete data ?
It sound like you are using Microsoft Access as your interface for
PostgreSQL. The 255-character limit is one of the (many) limitations
of MS Access.
You can force MS Access to recognize the full text of the field by
re-declaring it, in the PostgreSQL source, as TEXT. MS Access will
then recognize the field as large text, and will access it as MEMO. Be
warned that Access imposes some limitations on querying a MEMO field.
If you are using something other than MS Access, please reply and
explain what tool you are using to interface with your PostgreSQL
database. The PostgreSQL version would also help.
-Josh Berkus
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Le Hibou | 2002-10-13 22:29:29 | Re: Problem with varchar |
| Previous Message | Le Hibou | 2002-10-13 21:58:45 | Problem with varchar |