happyz
/
memos
mirror of https://github.com/usememos/memos.git
1
0
Fork 0
Code Issues Packages Projects Releases Wiki Activity
memos/store/db/sqlite
History
Steven 8770b186e4 fix: add Unicode case-insensitive search for SQLite (#5559) 
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
 		2026-02-02 21:10:07 +08:00
..
activity.go chore: fix postgres stmts 2024-01-05 21:27:16 +08:00
attachment.go refactor(db): rename tables for clarity - resource→attachment, system_setting→instance_setting 2026-01-06 23:36:42 +08:00
common.go chore: impl inbox store methods 2023-10-27 08:17:58 +08:00
functions.go fix: add Unicode case-insensitive search for SQLite (#5559) 2026-02-02 21:10:07 +08:00
idp.go chore: migrate idp service 2024-04-13 10:50:25 +08:00
inbox.go test: optimize store tests performance by reusing docker image and reducing build context 2026-01-12 23:30:56 +08:00
instance_setting.go revert: revert system_setting to instance_setting rename changes 2026-01-07 20:38:02 +08:00
memo.go feat: allow setting custom timestamps when creating memos and comments 2026-01-17 12:56:03 +08:00
memo_relation.go test: optimize store tests performance by reusing docker image and reducing build context 2026-01-12 23:30:56 +08:00
reaction.go fix(security): implement security review recommendations (#5228) 2025-11-06 23:32:27 +08:00
sqlite.go fix: add Unicode case-insensitive search for SQLite (#5559) 2026-02-02 21:10:07 +08:00
user.go refactor: memo filter 2025-10-16 09:22:52 +08:00
user_setting.go refactor: user auth improvements (#5360) 2025-12-18 18:15:51 +08:00