asked on

Case Sensitive data in Firebird

Hi
Right now i am shifting my code from SQLServer to FireBird.In SQLServer all queries give records where the data searched is Case-InSensitive while in firebird it is case sensitive.So now i will have to change all the searchable data to lowercase and then write. Is there any other way to force the database to search Case-InSensitive Data.

Ajay

ASKER CERTIFIED SOLUTION

JMelchhammer

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

vogonPoet

Hi!

One thing to try, is a CONTAINING condition:

SELECT EMP_NO FROM EMPLOYEE
WHERE LNAME CONTAINING "smith"

CONTAINING is case-insensitive and
finds partial matches.

Like:

Smith
SMITH
Wordsmith

CAUTION: Containing will not used indeces. For best performance, make sure to limit the query with other
conditions if you need to run over a large table.

BAlexandrov

If you select case insensitive collation then searches will be case insensitive.

Bojidar Alexandrov

kacor

Hi ajay_bhosle,

if you got the needed answer, please accept it by clicking on Accept in the header of the good answer. By this way you can express thanks for expert's support

with best regards

Janos

kacor

No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area for this question:
to accept JMelchhammer's answer
Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

kacor
EE Cleanup Volunteer