Hello, Trailing spaces seem to be removed by H2 on varchar columns.
Example, run this in dbconsole: CREATE TABLE TEST(ID INT PRIMARY KEY, NAME VARCHAR(255)); INSERT INTO TEST VALUES(1, 'Hello '); SELECT * FROM TEST; name is then returned as 'Hello' Tested on H2 1.4.200 (2019-10-14) Is there a setting to disable this? -- 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/5182749e-333c-4686-91b0-361085fbfa4b%40googlegroups.com.
