Column data is too big to store

Hi friends,

 

I am getting the below error in Vertica:

 

Error: [Vertica][VJDBC](4800) ERROR: String of 1772 octets is too long for type Varchar(255)

 

I can get rid of this issue using LONG VARCHAR datatype. or do you guys have others solution aprt from creating multiple columns into pieces.

 

Any performance issue using LONG VARCHAR ?

 

Thank you.

 

Regards,

Kushal

 

Comments

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.