MDM search case sensitive while using RDBMS db

Overview

MDM webUI search in-casesensitive using xmldb(exist/qizx) while it is not of this case by using RDBMS db

Environment

MDM 5.2.1 using RDBMS db

Symptoms/Description

From 5.2.1, talend MDM support RDBMS db, webUI search in-casesensitive using xmldb(exist/qizx) while it is not of this case by using RDBMS db

Resolution

  •  for mysql db, please refer to http://dev.mysql.com/doc/refman/5.0/en/case-sensitivity.html
  •  for oracle db, you can create a logon trigger like:

     

    create or replace
    TRIGGER SYSTEM.SET_NLS_ONLOGON
    AFTER LOGON
    ON DATABASE
    DECLARE
        cmmd1 VARCHAR2(100);
        cmmd2 VARCHAR2(100);
    BEGIN
        cmmd1:='ALTER SESSION SET NLS_SORT=BINARY_CI';
        cmmd2:='ALTER SESSION SET NLS_COMP=LINGUISTIC';
         
         EXECUTE IMMEDIATE cmmd1;
         EXECUTE IMMEDIATE cmmd2;
        
    END SET_NLS_ONLOGON;
    Icon

    From 5.3.0 , there is a minor feature about the issue, please refer toTMDM-5352 - Add an option to make CONTAINS operator case insensitiveCLOSED

     

Version History
Revision #:
1 of 1
Last update:
‎05-11-2017 08:49 PM
Updated by:
 
Labels (1)
Contributors