Ignore letters size in search

QuestionsIgnore letters size in search
jm asked 5 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
Abu Ghufran answered 5 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.

jm answered 5 years ago

Hello,

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

Regards.

Abu Ghufran answered 5 years ago

I just emailed you pgsql update.

jm answered 5 years ago

It works. Full success. Thank you.

Your Answer

15 + 10 =

Login with your Social Id:

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.



How useful was this discussion?

Click on a star to rate it!

Average rating / 5. Vote count:

We are sorry that this post was not useful for you!

Let us improve this post!