Breaking News: Grepper is joining You.com. Read the official announcement!

value too long for type character varying(255)

Santino answered on March 3, 2021 Popularity 10/10 Helpfulness 1/10

answer value too long for type character varying(255)

value too long for type character varying(255)

Comment

-1

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) <= 500) 

column_name TEXT CHECK (length(column_name) <= 500)

Popularity 10/10 Helpfulness 1/10 Language whatever

Source: Grepper

Tags: character whatever

Link to this answer
Share Copy Link

Contributed on Mar 03 2021

Santino

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

value too long for type character varying(255)

Contents

More Related Answers

value too long for type character varying(255)

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.