In my account collector, i did not check the "Data is case senesitive" chekbox.
But i have some orphans accounts not mapped cause, it has some uppercase letters in its names
select count(*) from PV_ORPHANED_ACCOUNT, PV_USERS where lower(PV_ORPHANED_ACCOUNT.NAME)=lower(PV_USERS.ADMIN_USER_NAME) or lower(PV_ORPHANED_ACCOUNT.NAME)=lower(PV_USERS.USER_NAME).
that query return 392 orphan account.
Note: in PV_USERS all columns are in lowercase.
I want know, how can i ignore case in the account mapping?