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.