Ignore letters size in search

Questions › Ignore letters size in search

jm asked 9 years ago

Hi,

I have declared the colums params and set the search option into advanced. Now, when I'd like to search something in the column, I have to take care what size of letters I use. I want to ignore it, put 'A' and find 'APPLE' and 'apple', too (now I'm getting 'APPLE' only).

Can You help me to solve the problem.

4 Answers

0 Vote Up Vote Down

Abu Ghufran answered 9 years ago

By default, it uses contains search which is case insensitive in mysql.
If you are using some other database, i am emailing you an udpated build for db2/oracle.

0 Vote Up Vote Down

jm answered 9 years ago

Hello,

Unfortunately, I am using PostgreSQL and it doesn’t work. Could You help me?

Regards.

0 Vote Up Vote Down

Abu Ghufran answered 9 years ago

I just emailed you pgsql update.

0 Vote Up Vote Down

jm answered 9 years ago

It works. Full success. Thank you.

Your Answer