ERROR: value too long for type character varying(255)

From: Doug Fields <dfields-pg-general(at)pexicom(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: ERROR: value too long for type character varying(255)
Date: 2002-05-21 16:17:38
Message-ID: 5.1.0.14.2.20020521121522.02a91088@mail.pexicom.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello again,

In PG 7.1.3, ISTR I used to be able to submit any length I wished for a
VARCHAR (and maybe a CHAR).

Now, I'm at 7.2.1 and get these errors:

ERROR: value too long for type character varying(255)

as JDBC Exceptions.

Do you know how I can tell it to "silently truncate" the data as I believe
it used to?

Many thanks,

Doug

PS: This group is great, and some of you (you know who you are) are amazing.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Lockhart 2002-05-21 16:21:30 Re: [GENERAL] Psql 7.2.1 Regress tests failed on RedHat 7.3
Previous Message Lamar Owen 2002-05-21 16:06:28 Re: [GENERAL] Psql 7.2.1 Regress tests failed on RedHat 7.3