db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rodent of Unusual Size <Ken.C...@Golux.Com>
Subject Re: Case Sensitivity
Date Fri, 25 Feb 2005 11:07:21 GMT

I don't actually use Derby, not being a Java person, but I *have* used
MySQL for years.  The case-sensitivity issue has bitten me before as
well, but in the other direction:

Satheesh Bandaram wrote:

> I don't think Derby has a property to create a database case
> insensitive. Why exactly do you need the database to be case
> insensitive? Derby has string functions to convert data to upper case or
> lower case, so it is possible for the application to store data in one
> case. (Either upper only or lower only by converting at the input time)
> All the searches after the database is created can then happen in that case.

There's case-sensitive, case-aware/case-preserving, and case-insensitive.
Is it actually the data that should be regarded as case-insensitive, or
search operations?  Case sensitivity makes a difference in collation results,
and I think that can be compounded in some non-ISO-8859-1 character sets.

For comparison, MySQL stores all data verbatim -- that is, case-sensitive.
By default, stringish search operations (WHERE foo LIKE 'bar%') are case
insensitive.  They can be made case-sensitive by labelling one of the
comparison operands as binary, either in the column definition (if appropriate)
or in the search expression (WHERE foo LIKE BINARY 'bar%').

See http://dev.mysql.com/doc/mysql/en/case-sensitivity.html

For what it's worth..
- --
#ken	P-)}

Ken Coar, Sanagendamgagwedweinini  http://Ken.Coar.Org/
Author, developer, opinionist      http://Apache-Server.Com/

"Millennium hand and shrimp!"
Version: GnuPG v1.2.4 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org


View raw message