Truncate a VARCHAR to specific length in Derby AUTOMATICALLY

Question

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.

Is there a easy way to suppress this exception?

Answer 1

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.