2. ASPRunnerPro General questions
  3. case insensitive to ı and I, or i and İ
This topic is locked

case insensitive to ı and I, or i and İ

 		1/30/2008 1:45:52 AM
ASPRunnerPro General questions
U
 uludag author

Hi,

I am using MS access database. I would like quick and advanced searches to be case insensitive to ı, i, I and İ.

I mean when someone search India, he/she must be able to find india, İndia or ındia as well as India.

Is that possible.

Sincerely,

Uludag.
J
 		Jane 1/30/2008

Hi,
search in the ASPRunner isn't case-sensitive.
U
 		uludag author 1/30/2008

Are you sure that, Jane?

When I search, for instance, Islam in my database, the number of records found is 919. For İslam, it is 1885. For islam, it is 919 again. For ıslam, it is just 2.

I and i are seems compatible. However, between I/i and İ there appears a problem. I want to solve this problem.

Sincerely,
Sergey Kornilov admin 1/30/2008

You are confusing case sensitivity with searching for accent characters.
MS Access treats I and İ as different characters.

Some other databases like SQL server can handle this.