CHARACTER is a fixed-width data type. Columns of CHARACTER data type always have exactly one character. Columns of CHARACTER(255) data type always have exactly 255 characters, shorted values are right-padded with spaces. If you need to store strings of different length, you should always use CHARACTER VARYING / VARCHAR data type instead. If you need to store exactly one character, you can use CHARACTER or CHARACTER(1); but don't use CHARACTER(255) for this purpose, such choice is obliviously wrong.
More details are described here: https://github.com/h2database/h2database/issues/3385 -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/04ff2b2c-b29f-4635-8b71-48d46b348dddn%40googlegroups.com.
