Database connection URL attributes that control collation When you create a database, the attributes that you set determine the collation that is used with all character data in the database. collationconnection URL attributes locale-based collationconnection URL attributes connection URL attributeslocale-based collation

The following table shows some examples.

Database creation URL attributes that control collationThis table shows how collation is controlled with various database creation URL attributes. Example Create URLs Collation Is Driven By jdbc:derby:abcDB;create=true Unicode codepoint collation (UCS_BASIC), which is the default collation for databases. jdbc:derby:abcDB;create=true;territory=es_MX Unicode codepoint collation (UCS_BASIC). The collation=collation attribute is not set. jdbc:derby:abcDB;create=true;collation=TERRITORY_BASED The locale of the JVM, since the territory=ll_CC attribute is not set. To determine the locale of the JVM, call the Locale.getDefault method. jdbc:derby:abcDB;create=true;territory=es_MX;collation=TERRITORY_BASED The territory=ll_CC attribute. jdbc:derby:abcDB;create=true;territory=es_MX;collation=TERRITORY_BASED:PRIMARY The territory=ll_CC attribute with collation strength PRIMARY, which makes the database case-insensitive (it typically means that only differences in base letters are considered significant).