• Steven's avatar
    fix: add Unicode case-insensitive search for SQLite (#5559) · 8770b186
    Steven authored
    Add custom memos_unicode_lower() SQLite function to enable proper
    case-insensitive text search for non-English languages (Cyrillic,
    Greek, CJK, etc.).
    
    Previously, SQLite's LOWER() only worked for ASCII characters due to
    modernc.org/sqlite lacking ICU extension. This caused searches for
    non-English text to be case-sensitive (e.g., searching 'блины' wouldn't
    find 'Блины').
    
    Changes:
    - Add store/db/sqlite/functions.go with Unicode case folding function
    - Register custom function using golang.org/x/text/cases.Fold()
    - Update filter renderer to use custom function for SQLite dialect
    - Add test for Unicode case-insensitive search
    - Make golang.org/x/text a direct dependency
    
    Fixes #5559
    8770b186
Name
Last commit
Last update
..
README.md Loading commit data...
activity_test.go Loading commit data...
attachment_filter_test.go Loading commit data...
attachment_test.go Loading commit data...
containers.go Loading commit data...
filter_helpers_test.go Loading commit data...
idp_test.go Loading commit data...
inbox_test.go Loading commit data...
instance_setting_test.go Loading commit data...
main_test.go Loading commit data...
memo_filter_test.go Loading commit data...
memo_relation_test.go Loading commit data...
memo_test.go Loading commit data...
migrator_test.go Loading commit data...
reaction_test.go Loading commit data...
store.go Loading commit data...
user_setting_test.go Loading commit data...
user_test.go Loading commit data...