Strange PostgreSQL value too long for type character varying 500

Question

I have a Postgres schema which looks like     The problem is that whenever I save text longer than 500 characters in the description column I get the error   value too long for type character varying 500    In the documentation for Postgres it says type text can have unlimited characters   I m using postgresql-9 1   This table has been generated using Django 1 4 and the field type in the model is TextField  if that helps explain the problem further   Any ideas as why this is happening and what I can do to fix it

User · Answer

We had this same issue  We solved it adding  length  to entity attribute definition    Column columnDefinition  text   length 10485760  private String configFileXml

User · Answer

By specifying the column as VARCHAR 500   you ve set an explicit 500 character limit  You might not have done this yourself explicitly  but Django has done it for you somewhere  Telling you where is hard when you haven t shown your model  the full error text  or the query that produced the error   If you don t want one  use an unqualified VARCHAR  or use the TEXT type   varchar and text are limited in length only by the system limits on column size - about 1GB - and by your memory  However  adding a length-qualifier to varchar sets a smaller limit manually  All of the following are largely equivalent   column name VARCHAR 500   column name VARCHAR CHECK  length column name   lt   500    column name TEXT CHECK  length column name   lt   500     The only differences are in how database metadata is reported and which SQLSTATE is raised when the constraint is violated   The length constraint is not generally obeyed in prepared statement parameters  function calls  etc  as shown   regress  gt   x Expanded display is on  regress  gt  PREPARE t2 varchar 500   AS SELECT  1  PREPARE regress  gt  EXECUTE t2  repeat  x  601     -  RECORD 1  -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  column    xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx   and in explicit casts it result in truncation   regress  gt  SELECT repeat  x  501   varchar 1   -  RECORD 1   repeat   x   so I think you are using a VARCHAR 500  column  and you re looking at the wrong table or wrong instance of the database

User · Answer

Character varying is different than text   Try running   ALTER TABLE product product ALTER COLUMN code TYPE text    That will change the column type to text  which is limited to some very large amount of data  you would probably never actually hit it

[sql] Strange PostgreSQL "value too long for type character varying(500)"

Examples related to sql

Examples related to database

Examples related to django

Examples related to postgresql

Examples related to postgresql-9.1