Is there a way to set default case-sensitivity on text filters in Toad Workbook?
I searched through settings and only saw a case-sensitivity setting for Object Explorer.
Thanks!
Eric
Hi Eric - in what area were you wanting to use case sensitive text filters?
I don't believe we offer case sensitivity choices on the on the result set pane search in Visual Query Builder or SQL Editor, but I was able to use the global where clause to inject a "collate" command in the editor to control whether the original SQL in the query step to make it case sensitive to variable inputs at run time. The command you will need to use will depend on your original data source. Here is what I added to the Global WHERE clause in my Visual Query Builder editor when I was querying MySQL:
(column_1 = :column_1 COLLATE utf8_bin)
We are using HANA SQL and the data is case-sensitive - was just wondering if there was a way to by default check this box all the time in the Where Condition window:
There is no way to do this now but I will add this to our dev backlog