Column data is too big to store

+1

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

+2

Hi

You can still used regulare varchar column, the max length of regulare varchar is 65K chars

Thanks

+1

Thanks!! The issue is resolved.

Sign up