Case insensitive search

Do you want to create a native client or integrate with third party applications: webservices are the solution.

Moderator: car031

Post Reply
Rabbit80
Posts: 29
Joined: Mon Oct 04, 2010 3:18 pm

Case insensitive search

Post by Rabbit80 » Wed Oct 25, 2017 9:44 am

When I am searching for a document by attributes, is it possible to make the search case insensitive?

For example - search by field ext_Department for "accounts" needs to return results for accounts, Accounts and ACCOUNTS. The caseSensitive flag appears to make no difference.

Is there any other way I can do this?

agaspa
Posts: 529
Joined: Tue Apr 20, 2010 8:24 am

Re: Case insensitive search

Post by agaspa » Mon Oct 30, 2017 5:52 pm

The search is case sensitive,
but the behaviour I think you're expected might be because of the settings of MySQL.
In particular under certain circumstances MySQL can returns results without respecting the case expressed in the query.

See also
MySQL case sensitive query

B.5.4.1 Case Sensitivity in String Searches

MySQL case insensitive select

Rabbit80
Posts: 29
Joined: Mon Oct 04, 2010 3:18 pm

Re: Case insensitive search

Post by Rabbit80 » Mon Oct 30, 2017 6:04 pm

I assume the table in question is ld_document_ext?

In this case, the collation is set to latin1_swedish_ci - the ci at the end denoting case-insensitive.

A search directly on the database appears to perform correctly..

SELECT * FROM logicaldoc.ld_document_ext WHERE ld_stringvalue = "accounts"; - returns results for all variations of the word accounts. Via webservices search it will only match exact case.

Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest