우리는 고르지우스 조지를 잃었다 (접근 불가 카테고리)

zogstrip · 2월 7, 2026, 7:09오후

감사합니다

이미 수정을 위한 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	5	171	8월 20, 2025
Why is there a category that I can't modify Support	14	1864	12월 17, 2021
Issue with a newly created category due to accent character in category name Support	3	840	11월 18, 2020
404 when trying to edit category with accent in slug Support	5	518	3월 18, 2022
Can't modify or delete category Support	12	910	3월 29, 2021

우리는 고르지우스 조지를 잃었다 (접근 불가 카테고리)

Related topics