We Lost Gorgeous George (unreachable category)

zogstrip · 7 februari 2026 om 19:09

Thanks

I’ve already made a PR for the fix

github.com/discourse/discourse

FIX: Use unaccent() for category name/slug search (#37622)

main ← fix/unaccent-category-search

merged 07:43AM - 12 Feb 26 UTC

ZogStriP

+139 -26

Categories with accented names (e.g. "Éditions") were not appearing in search re…sults, category chooser dropdowns, or hashtag autocomplete when searching with unaccented terms (e.g. "editions"). PostgreSQL's `ILIKE` and `LOWER()` are case-insensitive but not accent-insensitive, so queries like `name ILIKE '%editions%'` would not match "Éditions". This wraps all category name/slug comparisons with PostgreSQL's `unaccent()` function across: - `/categories/search` endpoint - `/categories/hierarchical_search` endpoint - Hashtag (#) autocomplete - `category:` and `#slug` search filters Introduces `Category.normalize_sql(expr)` helper that wraps SQL expressions with `lower(unaccent(...))` to centralize the normalization logic and make it easier to extend in the future. On the frontend, adds a shared `removeAccents()` utility using NFD normalization for client-side `Category.search()` and search filter suggestions. Ref - https://meta.discourse.org/t/395355

Topic		Antwoorden	Weergaven
Non-ASCII in category name: doesn't prettify slug Bug	6	87	20 augustus 2025
Why is there a category that I can't modify Support	14	1709	17 december 2021
Issue with a newly created category due to accent character in category name Support	3	729	18 november 2020
404 when trying to edit category with accent in slug Support	6	476	18 maart 2022
Can't modify or delete category Support	12	815	29 maart 2021

We Lost Gorgeous George (unreachable category)

Gerelateerde topics