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?
Case insensitive search
Moderator: car031
Post
Re: Case insensitive search
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
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
Post
Re: Case insensitive search
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.
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.
- EdwardMarce
- Contact:
- Location: Zimbabwe
Post
Case insensitive search
I want to implement a database search that is insensitive to plural/singular, order and case of the words used in an input string. I am using MySQL database. For example if the input string is:
woman looking for a desktop, Printers and laptopS
the search must return all rows that contain any of the following words or phrases containing any of the following words in any order and whether they contain upper or lower case letters:
woman women desktop desktops printer printers laptop laptops
How do I do this?
MySQL fulltext search cannot handle the plural/singular and regular expressions in MySQL are sensitive to the order of the words.
woman looking for a desktop, Printers and laptopS
the search must return all rows that contain any of the following words or phrases containing any of the following words in any order and whether they contain upper or lower case letters:
woman women desktop desktops printer printers laptop laptops
How do I do this?
MySQL fulltext search cannot handle the plural/singular and regular expressions in MySQL are sensitive to the order of the words.
Who is online
Users browsing this forum: No registered users and 1 guest