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.






Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
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.