java - VARCHAR does not work as expected in Apache Derby -

I am getting:

How do I sort a VARCHAR in the length of the table area Can I use SQL automatically in derby?

To be specific:

Create a table A (B worker (2)); Include B values ​​('1234'); A SQLException will be thrown:

A truncation error was trying to the length of VARCHAR '123' 2.

that has already responded to:

After checking the meta-data, you should close it or if you have meta-data every Do not want to check times, you have to keep your code and database in sync. But this is not a big deal, it is a common practice among the legalists.

But my doubt is: is not the VARCHAR to vary the size of the data size? What's wrong with Apache Derby's VARCHAR?

The VARCHAR type is variable length, but the number you give it in its definition The maximum is the number of letters that you allow.

will store VARCHAR (2) values, which are as 0 characters, as opposed to CRAR (2) , despite it Regardless of 2 letters, what will this data?

Side note: Once you have 255 characters, consider using the TEXT type instead.