-
1. Re: Criteria case sensitive in Queries
Dominik Kress Jul 31, 2019 8:38 AM (in response to Andrey Gabriel)1 of 1 people found this helpfulHi Andrey,
Which Database do you use? I've seen this when Postgres is used as DB. My guess would be wrong configuration of your DB. So when your DB is case sensitive BCM will also be case sensitive.
Edit:
Screenshot query:
Screenshot preview:
-
2. Re: Criteria case sensitive in Queries
Andrey Gabriel Jul 31, 2019 8:52 AM (in response to Dominik Kress)Bonjour Dominik,
It's Oracle, but good tip .. Il will check with the DB master !
Thanks
-
3. Re: Criteria case sensitive in Queries
Dominik Kress Jul 31, 2019 9:05 AM (in response to Andrey Gabriel)1 of 1 people found this helpfulHi Andrey,
If your DB master find the setting to switch from case sensitive to case insensitive it would be great to update the discussion with your solution.
-
4. Re: Criteria case sensitive in Queries
Andrey Gabriel Aug 5, 2019 3:36 AM (in response to Dominik Kress)Bonjour Dominik Kress,
Yes the records in the DB are in upper/lower case, so not a good solution to modify on the DB.
I can make Free Queries, but then, as I could not mix regular and free queries I have to choose a solution between:
- Using like(SQL) operator with %ac%OS% and hope that Apple will not change theire way gto name theire OS
- Changing all the queries which need an UPPER (tables.objectname) Like N'something' to be case unsensitiv (hard way for maintening)
- Ask to BMC to have theire 'Contain' operator acting as it is in the Find tool
-
5. Re: Criteria case sensitive in Queries
Andrey Gabriel Aug 5, 2019 3:28 AM (in response to Andrey Gabriel)I feel it's acting like that
Where operator value
Find Tool contains UPPER (Table.ObjectName) LIKE N'something'
Query contains Table.ObjectName LIKE N'something'
-
6. Re: Criteria case sensitive in Queries
Dominik Kress Aug 5, 2019 4:19 AM (in response to Andrey Gabriel)1 of 1 people found this helpfulHi Andrey,
I would not wait until BMC does change it. This may could take a while. You should consider to contact tech support or your support partner to get the DB requirements and with this your DB admin is able to verify if everything is configured correct.
just an extract from another source:
Oracle databases are by default configured as case sensitive. Version 10gR2 added a new feature to its NLS (National Language Support) that allows to do case-insensitive sorts and comparisons altering the session settings.
This can be done changing the value of two NLS parameters, NLS_SORT and NLS_COMP.
Regards,
Dominik
-
7. Re: Criteria case sensitive in Queries
Andrey Gabriel Aug 27, 2019 7:27 AM (in response to Andrey Gabriel)Sorry for late answer
Oracle DB 10gR2
-
8. Re: Criteria case sensitive in Queries
Nathalie ObadiaSep 2, 2019 3:00 AM (in response to Andrey Gabriel)
Hi Audrey,
There is an Administrator Preference: Miscellaneous/Advanced Search Case Sensitive
We apply this preference for criterion values.Nathalie