To define whether text comparisons are case-sensitive:

 

CASESENSITIVE = 0

 

If CaseSensitive = 0, it will ignore the case during comparisons unless the query is executed in pass-through mode and the target database has a contrary behavior.

If  CaseSensitive = 1, it will respect the case during comparisons unless the query is executed in pass-through mode and the target database has a contrary behavior.

Default = 0

 

Environments: Client, Windows, Unix

Configuration Manager: CONNX Settings; Current Key = CONNX; Key Value/Value Name =  CASESENSITIVE

 

Unix Registry Setting: CONNX.CASESENSITIVE