Managing the case-sensitivity in database searches

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

Procedure

Edit the <$INSTALLDIR>\conf\datasources.xml file.

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!

Leave your feedback here