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 h2-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/04ff2b2c-b29f-4635-8b71-48d46b348dddn%40googlegroups.com.