Мы потеряли Прекрасного Джорджа (недоступная категория)

zogstrip · 07.Февраль.2026 19:09:32

Спасибо

Я уже создал PR с исправлением

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

Тема		Ответов	Просм.
Non-ASCII in category name: doesn't prettify slug Bug	6	105	20.08.2025
Why is there a category that I can't modify Support	14	1779	17.12.2021
Issue with a newly created category due to accent character in category name Support	3	743	18.11.2020
404 when trying to edit category with accent in slug Support	6	487	18.03.2022
Can't modify or delete category Support	12	846	29.03.2021

Мы потеряли Прекрасного Джорджа (недоступная категория)

Связанные темы