Case Insensitive

nemo

unread,

Dec 23, 2009, 10:37:20 PM12/23/09

to H2 Database

How to make Case Insensitive search in H2 with "like" clause?

nemo

unread,

Dec 24, 2009, 3:05:24 AM12/24/09

to H2 Database

I am so sorry - I've found this theme in this group.

I like to say thank you for a great product. Would be preferable if I
may to remove index files temporarily and rebuild them later-
they takes too dig space . So it hard to explain to user why data base
is so big ...

Thomas Mueller

unread,

Dec 27, 2009, 11:04:24 AM12/27/09

to h2-da...@googlegroups.com

Hi,

> Would be preferable if I
> may to remove index files temporarily and rebuild them later-
> they takes too dig space . So it hard to explain to user why data base
> is so big ...

Did you try the latest version (1.2.126)? The database files should be
smaller now.

Regards,
Thomas

SERGEY SUKHOTSKIY

unread,

Jan 2, 2010, 7:50:18 AM1/2/10

to h2-da...@googlegroups.com

Yes I downloaded last version but database files has exactly same size

--

You received this message because you are subscribed to the Google Groups "H2 Database" group.
To post to this group, send email to h2-da...@googlegroups.com.
To unsubscribe from this group, send email to h2-database...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.

Thomas Mueller

unread,

Jan 4, 2010, 3:06:53 PM1/4/10

to h2-da...@googlegroups.com

Hi,

> why data base is so big

Could you describe what kind of data you store in the database, how
big the database file is, and how big you expect it to be?

> How to make Case Insensitive search

A) use VARCHAR_IGNORECASE:
http://www.h2database.com/html/datatypes.html#varchar_ignorecase_type
B) use UPPER(name) LIKE UPPER('pattern%')