VARCHAR does not work as expected in Apache Derby
- by Tom Brito
I'm having this same problem:
How can I truncate a VARCHAR to the
table field length AUTOMATICALLY in
Derby using SQL?
To be specific:
CREATE TABLE A ( B VARCHAR(2) );
INSERT INTO A B VALUES ('1234'); would
throw a SQLException:
A truncation error was encountered
trying to shrink VARCHAR '123' to
length 2.
that is already answered:
No. You should chop it off after
checking the meta-data. Or if you
don't wanna check the meta-data
everytime, then you must keep both
your code and database in sync. But
thats not a big deal, its a usual
practice in validators.
but my doubt is: isn't VARCHAR suppose to variate its size to fit the data? What's wrong with apache derby's VARCHAR?
