Skip to main content
Question

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


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.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings