SQLite Forum

Joining on Hebrew words including vowel points and cantillation marks
Login
This may not be an area in which many people are interested, but I was given an answer on stackoverflow concerning how to accomplish this in Tcl and Linux.

The answer is here if links are permitted. (https://stackoverflow.com/questions/67629309/unicode-normalization-of-hebrew-in-tcl-sqlite-or-whatever-else-will-work-in-li/67635812#67635812)

The main part is this procedure provided by Donal Fellows.

proc normalize {string {form nfc}} {
    exec uconv -f utf-8 -t utf-8 -x "::$form;" << $string
}