mugiten/tamerye
0
0
Fork 0
Code Issues 12 Pull Requests Actions Releases Activity

Add a collation that equates hira/katakana #6

New Issue
Open
opened 2026-05-07 08:10:51 +02:00 by oysteikt · 1 comment
oysteikt commented 2026-05-07 08:10:51 +02:00
Owner
Copy Link
Copy Source

It would be nice to have a collation that equates these kana, among other things.

Consider also supporting half-width kana.

Consider equating certain symbols like ./。 and ,/、, as well as whitespace.

https://sqlite.org/datatype3.html#collation
https://sqlite.org/c3ref/create_collation.html

It would be nice to have a collation that equates these kana, among other things. Consider also supporting half-width kana. Consider equating certain symbols like `.`/`。` and `,`/`、`, as well as whitespace. https://sqlite.org/datatype3.html#collation https://sqlite.org/c3ref/create_collation.html
oysteikt added the feature request label 2026-05-07 08:10:51 +02:00
oysteikt added this to the Kanban project 2026-05-07 08:10:51 +02:00
oysteikt commented 2026-05-07 11:42:46 +02:00
Author
Owner
Copy Link
Copy Source

Unfortunately, the collation does not affect the LIKE operator. That seems to be the same issue as in mugiten/jadb#93. In order to override LIKE, we might need to use a virtual table instead of a collation.

Unfortunately, the collation does not affect the `LIKE` operator. That seems to be the same issue as in https://git.pvv.ntnu.no/mugiten/jadb/issues/93. In order to override LIKE, we might need to use a virtual table instead of a collation.
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
art
Requires some creativity
 big
This is gonna take a while
 blocked
This issue/PR depends on one or more other issues/PRs
 bug
Something brokey
 ci-cd
Continuous integrals and continuous derivation
 crash report
Report an oopsie
 data source
New data source / use more data from existing data source
 disputed
Kranglefanter
 documentation
Documentation changes required
 duplicate
This issue or pull request already exists
 feature request
good first issue
Get your hands dirty with a new project here
 me gusta
( ͡° ͜ʖ ͡°)
 nix
packaging
question
security
Skommel
 techdebt spring cleaning
The code is smelly 👃
 testing
Poke it and see if it explodes
 ui/ux
User complaints about ergonomics and economics and whatever
 wontfix
Nei, vil ikke
No Label feature request
Milestone
No items
No Milestone
Projects
Clear projects
No project Kanban
Assignees
Clear assignees
oysteikt (Oystein Kristoffer Tveit)
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: mugiten/tamerye#6
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?