db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Satheesh Bandaram <sathe...@Sourcery.Org>
Subject Re: Case Sensitivity
Date Wed, 16 Feb 2005 08:21:40 GMT
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.


Devang wrote:

>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?
>Devang Gandhi

View raw message