Skip to main content
Question

Error was 'ERROR: value too long for type character varying(50)

  • August 26, 2022
  • 2 replies
  • 473 views

Good morning,

I’m trying to transfer data from ESRI to PostGis.

Unfortunately, I encounter the following error:

Error was 'ERROR: value too long for type character varying(50)

I understand that the created field is too short but I can’t change it...

Thank you for your help.

2 replies

tomfriedl
Contributor
Forum|alt.badge.img+13
  • Contributor
  • August 26, 2022

"but I can’t change it..."

so you must shorten the string with the SubstringExtractor.


Forum|alt.badge.img+2
  • August 29, 2022

@renaud_nm​ I agree with @tomfriedl​ . You'll have to isolate the long text strings by testing the length > 50 and then try and find a pattern to shorten them. Either remove spaces or other none word characters.