Creating a case-insensitive database

Creating a case-insensitive database When you create a database using locale-based collation, the collation=collation value TERRITORY_BASED uses the default collation strength for the locale, usually TERTIARY, which will consider character case significant in searches and comparisons. database attributes case-insensitive collation collation case-insensitive

To make the database use case-insensitive searches, specify an explicit strength lower than TERTIARY with the collation=collation attribute. The strength name is appended to TERRITORY_BASED with a colon to separate them.

For example, you could specify the following connection URL:

jdbc:derby:SwedishDB;create=true;territory=sv_SE;collation=TERRITORY_BASED:PRIMARY

With strength PRIMARY, the characters 'A' and 'a' will be considered equal, as well as 'à' ('a' with a grave accent). (This behavior is commonly the default with many other databases.) To make searches respect differences in accent, use strength SECONDARY.

The exact interpretation of the strength part of the attribute depends upon the locale.

For more information, see and the documentation of the territory=ll_CC and collation=collation attributes in the .