ERROR: String of 12 octets is too long for type Varchar(10)
The problem is that when I try to insert a varchar value of length more than the actual defined length of the column, Vertica throws an error.
For example: Inserting "DUMMY_INSERT" into a column of length VARCHAR(10)
Here DUMMY_INSERT is of 12 characters.
Sybase IQ automatically trims the string value to the limit defined in the table i.e. 10 characters. So when i perform the same insert operation in Sybase it would insert "DUMMY_INSE" into the same column.
Can I achieve similar functionality in Vertica where the data gets auto-trimmed and gets inserted?? I dont wish to manually use TRIM or substring everywhere to trim the data.
Any inputs would be much appreciated.