search

CentreForDigitalHumanities / idioms

Database of Dutch Dialect Idioms
https://dutchdialectidioms.uu.nl/
Other
0 stars 0 forks source link

Make search query case insensitive #17

Closed ar-jan closed 2 years ago

ar-jan commented 2 years ago

Change strategy_data.value_definition_id to collate nocase.

The case for some parameter values is inconsistent, but we need a check using IN ('value').

ar-jan commented 2 years ago

Implemented directly in in the query so we don't need to add migration infrastructure. Performance looks fine, but declaring collate nocase in the index may be faster.