tokcum
05/09/2022, 1:09 PMRefusePassworChange
or refusepassworchange
. I did some research on how to query with case insensitive and after some tests with lower(), I found this solution:
SELECT * FROM registry WHERE path = "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Netlogon\Parameters\RefusePassworChange" COLLATE NOCASE;
Without "COLLATE NOCASE" this statement will not match different spellings like "refusepasswordchange".
Any other thoughts on this?defensivedepth
05/10/2022, 10:53 AMseph
05/10/2022, 4:55 PMpath =
filter, it has to match.path =
does double duty. First, it is passed to the underlying table’s generate routine to generate data.
Second, it’s used by sqlite to filter.defensivedepth
05/10/2022, 5:53 PMseph
05/10/2022, 6:47 PMCOLLATE NOCASE
is a good one
• LIKE
is always case insensitive
• lower()
probably also good
I don’t remember if there are performance implications. But probably not, since you’re hitting the registry so it’s not going to be that fastdefensivedepth
05/11/2022, 10:04 AMtokcum
05/11/2022, 2:25 PMseph
05/11/2022, 3:27 PM