Ok, thank you. Is it possible to reduce the size of the file again? > Am 13.07.2017 um 18:08 schrieb Fred Toussi via hsqldb-developers > <hsqldb-developers@lists.sourceforge.net>: > > This is normal. An uppercase copy of the CLOB is created. To avoid it, > cast the CLOB to VARCHAR before converting to uppercase. > > Fred Toussi > >> On Thu, Jul 13, 2017, at 10:52, Alexander Gerbig wrote: >> Hallo hsqldb developers, >> >> we use a hsqldb in our application an experience a strange behavior. We >> have some clob columns in different tables and when we execute an select >> with an upper on the clob column in a where clause the lobs file >> increases in size. Is it a very practice to make an upper on an clob >> column? Is this normal? >> >> Thanks for any help. >> >> Bye >> Alex >> ------------------------------------------------------------------------------ >> Check out the vibrant tech community on one of the world's most >> engaging tech sites, Slashdot.org! http://sdm.link/slashdot >> _______________________________________________ >> hsqldb-developers mailing list >> hsqldb-developers@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/hsqldb-developers > > ------------------------------------------------------------------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > _______________________________________________ > hsqldb-developers mailing list > hsqldb-developers@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/hsqldb-developers
------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot _______________________________________________ hsqldb-developers mailing list hsqldb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hsqldb-developers
