Thread: Problem with varchar

Problem with varchar

From
Le Hibou
Date:
hi,

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 ?


thanks




Re: Problem with varchar

From
"Josh Berkus"
Date:
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

Re: Problem with varchar

From
Le Hibou
Date:
Hi

   |   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.

i use
PostgreSQL Version 7.2.1
PostgreSQL Admin

Stan

Re: Problem with varchar

From
Le Hibou
Date:
   |   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.

i use
PostgreSQL Version 7.2.1
PostgreSQL Admin
and PHP for the development


Stan

Re: Problem with varchar

From
"Josh Berkus"
Date:
Le Hibou,

> i use
> PostgreSQL Version 7.2.1
> PostgreSQL Admin
> and PHP for the development

By PostgreSQL Admin, do you mean PGAdminII?   If so, PGAdmin has its
own mailing list, which can probably answer your question.

http://pgadmin.postgresql.org/pgadmin2.php?ContentID=4

-Josh Berkus