Case Sensitivity

[Devang <de...@molecularconnections.com>]

Hi

While developing the application in java with using Derby as a Database, I
found that except SQL Keywords the rest of the data is considered as Case
Sensitive. So I want to know the property through which I can create a
Database Case Insensitive?

Thanx

Devang Gandhi

Re: Case Sensitivity

[Rodent of Unusual Size <Ke...@Golux.Com>]

-----BEGIN PGP SIGNED MESSAGE-----

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!"
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iQCVAwUBQh8G55rNPMCpn3XdAQEPjgQA3gEcRky+K1qqLf8SmFAjfbh7ORBYrsKY
MYOVS9r1H2U617wKGQFOUquVKWsN4DdN8PlslzVaXNjYV1ppvDquk4Yl4prH6OV+
VuSGnecTHRVhRT//QhhimPTXZrk/r1q32VTEK4kDQSfuuDkrHYSFJkrH+f7UZGA8
OqxsQ4QUZJs=
=Yla1
-----END PGP SIGNATURE-----

Re: Case Sensitivity

[Satheesh Bandaram <sa...@Sourcery.Org>]

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.

Satheesh

Devang wrote:

>Hi
>
>While developing the application in java with using Derby as a Database, I
>found that except SQL Keywords the rest of the data is considered as Case
>Sensitive. So I want to know the property through which I can create a
>Database Case Insensitive?
>
>Thanx
>
>Devang Gandhi
>
>
>
>  
>

Re: Case Sensitivity

[Jeremy Boynes <jb...@apache.org>]

Devang wrote:
> Hi
> 
> While developing the application in java with using Derby as a Database, I
> found that except SQL Keywords the rest of the data is considered as Case
> Sensitive. So I want to know the property through which I can create a
> Database Case Insensitive?
> 

There was a recent thread on this. Short answer is Derby sticks with the 
SQL spec and treats values as case sensitive; there is no property for this.

--
Jeremy