We Lost Gorgeous George (unreachable category)

zogstrip · February 7, 2026, 7:09pm

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

opened 05:55PM - 07 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		Replies	Views
Non-ASCII in category name: doesn't prettify slug Bug	6	86	August 20, 2025
Why is there a category that I can't modify Support	14	1691	December 17, 2021
Issue with a newly created category due to accent character in category name Support	3	726	November 18, 2020
404 when trying to edit category with accent in slug Support	6	472	March 18, 2022
Can't modify or delete category Support	12	793	March 29, 2021

We Lost Gorgeous George (unreachable category)

Related topics