Here’s a question from left field.
I have a large deck of 1000+ that contains a particular field that contains many Unicode characters that doesn’t sort the way I want. E.g., Characters with certain diacritical marks like macrons (e.g., ā) all sort to the bottom, as though the sorting were being done on the Unicode codepoint value rather than a case-folded value of the letter.
So, to be specific, I want this sort order:
aec, āio, art, ātm, azz
aec, art, azz, āio, ātm
as is currently the case.
As I wouldn’t dare to suggest that Anki change something as fundamental as its sort ordering code on my account, I’m content to implement a workaround, which would be to add a duplicate of the existing field, along with the values from the original field, except for case-folding of the characters not in the Latin-1 character-set. I’m happy to do this case-folding by manual editing. I just don’t want to have to copy all the values from the original field to the duplicate field. But, unless I am overlooking something, I see no function in Anki desktop to accomplish this.
However, I do note that Anki uses SQLite3 database as its data engine. Since I’m au fait with SQLite, I’m happy to tweak the collection.anki2 data file directly. But, this seems risky.
So, my question is, if I manually edit the data file, will this break my deck or otherwise possibly put it in an inconsistent state that Anki will have trouble dealing with?
Many thanks in advance.