Hi,
Our development team is adding DB2 8.1 compatibility to our existing
application which currently supports SQLServer 2000. Our code is
written to take advantage of SQLServer's ability to allow query
string compares to be case insensitive. We have identified DB2 forces
all query string compares to be evaluated case sensitive. Since our
code is written to assume case insensitivity, it curently seems that
we must change our code base to force each compare to be case
insensitive in order to be compatible with DB2.
We are looking for a configuration option or similar mechanism for DB2
8.1 to allow for all query string compares to be case insensitive by
default. This is to allow us to avoid making any changes in our code
to compensate for the case sensitive nature of DB2 string compares.
Specifically: what we are looking for is a way that the code:
WHERE lastname = UPPER('Geyer')
can be coded as
WHERE lastname ='Geyer'
and any combination of case in the data that = 'geyer' would match.
1. Does DB2 8.1 have a mechanism for changing all query string
compares to be case insensitive?
2. If not, what is the recommended technique for performing case
insensitive string compares in DB2?
3. If not, does IBM have plans to enable case insensitive string
compares in DB2 in an upcoming release?
Thanx much,
Tom