Skip to main content Skip to complementary content

Managing the case-sensitivity in database searches

Depending on the configuration of your SQL database, searches in the database may be case sensitive.

Procedure

  1. Edit the <$INSTALLDIR>/conf/datasources.xml file.
  2. To make searches case insensitive, set the value of the <case-sensitive-search> option to false.
    For example:
    <datasources xmlns="http://www.talend.com/mdm/datasources">
        <datasource name="MySQL-DS1">
            <master>
                <type>RDBMS</type>
                <rdbms-configuration>
                    ...
                    <case-sensitive-search>false</case-sensitive-search>
                    ...
                </rdbms-configuration>
            </master>
        </datasource>
    </datasources>
    If this option is not available, all searches performed against the database are case sensitive.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!