Re: Problem with varchar - Mailing list pgsql-novice

From Josh Berkus
Subject Re: Problem with varchar
Date
Msg-id web-1785314@davinci.ethosmedia.com
Whole thread Raw
In response to Problem with varchar  (Le Hibou <le.hibou@wanadoo.fr>)
Responses Re: Problem with varchar  (Le Hibou <le.hibou@wanadoo.fr>)
Re: Problem with varchar  (Le Hibou <le.hibou@wanadoo.fr>)
List 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

pgsql-novice by date:

Previous
From: Le Hibou
Date:
Subject: Problem with varchar
Next
From: Le Hibou
Date:
Subject: Re: Problem with varchar