The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-17. For the latest, interactive version please visit https://mariadb.com/kb/.

case insensitive columns

My company has a strong need to be able to search via case insensitive columns - such as address which is virtually impossible to specify because of all of the variations of how the incoming data were supplied in terms of case.

Is this possible on a Linux based MariaDB columns store instance?

Thanks.

Answer Answered by David Thompson in this comment.

A key thing to remember is that columnstore implements its own set of 'distributed functions' that are executed at the pm level for scaling out query execution. At this point in time we don't support the collations that allow case insensitive matching. https://jira.mariadb.org/browse/MCOL-495 tracks an enhancement request to allow case insensitive matching.

The only solution for now is to store another column where you convert the text to lower case (or upper case) and then match on that with a lower case value.

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.