I have written a note taking app, that among other things shows notes in a TextArea and saves them to an SQLite database as RTFData (or more specifically I use some declares to get the RTF data). I implemented a search method that reads text from a TextField, modifies a prepared statement and loads only data containing the search string from an SQLite database to a record set.
That works very well when I search for German or English words, but I also have some ancient greek text passages among my notes, and there the search doesn’t work. The reason seems to be that the RTF data are converted to unicode; e.g. when I type the word “???” (idleness) in the TextArea, it is automatically saved as "\u963 \u967 \u959 \u955 \u942 " in the database, so that the lemma “???” in the search field doesn’t get any results.
Can you think of a proper way to convert my characters to unicode in order to compare them to the stored data? I am completely at a loss here