[h2] Re: No AUTO_INCREMENT in DatabaseMetaData.getTypeInfo()

This problem has been solved and I would particularly like to thank @ *Katzyn* and @*Evgenij* for their help and their reactivity... Le lundi 4 juillet 2022 à 12:20:17 UTC+2, prrvchr a écrit : > Hi Evgenij, > > I just saw that Katzyn has already committed the correction >

[h2] Re: LOWER function does not work as expected in v 2.1.214

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

[h2] Re: LOWER function does not work as expected in v 2.1.214

That was a good hint, I realized that my data structure is not optimized.. I am using a JAVA application and the tables are automatically created on startup. Therefore I never looked for the whole TEST CASE..The datatype Character (JAVA) is mapped to CHARACTER(255) and it is filled by blanks.

[h2] Re: LOWER function does not work as expected in v 2.1.214

Hello! You need to provide a complete test case. Something like CREATE TABLE XXX(XYZ VARCHAR(100), …); INSERT INTO XXX(XYZ, …) VALUES (…); SELECT * FROM XXX WHERE LOWER(XYZ) = 'somevalue'; -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To

[h2] Re: No AUTO_INCREMENT in DatabaseMetaData.getTypeInfo()

Hi Evgenij, I just saw that Katzyn has already committed the correction . Maybe you know where I can find the corrected H2 jar archive? And maybe you can help me to finish the integration of auto increment in Base? Apparently H2 does not

[h2] LOWER function does not work as expected in v 2.1.214

Hi together, do yo also have the problem that the lower function delivers empty results though it should return results? I am using h2 in version 2.1.214 as an in-memory database with my spring boot application and since the upgrade from v1.x to 2.x the lower function does not work as

[h2] lower function not working in version 2.1.214

Hello all together, I am using h2 in my spring boot application as an in-memory database. I am using it now in version 2.1.214 and the lower function is nor working as expected. Since the upgrade from version 1.x simple queries like "SELECT * FROM ... WHERE LOWER(...) = 'xx' delivery empty