On 13.02.24 03:01, Jeff Davis wrote:
> 1. The SQL spec mentions the capitalization of "ß" as "SS"
> specifically. Should UCS_BASIC use the unconditional mappings in
> SpecialCasing.txt? I already have some code to do that (not posted
> yet).
It is my understanding that "correct" Unicode case conversion needs to
use at least some parts of SpecialCasing.txt. The header of the file says
"For compatibility, the UnicodeData.txt file only contains simple case
mappings for characters where they are one-to-one and independent of
context and language. The data in this file, combined with the simple
case mappings in UnicodeData.txt, defines the full case mappings [...]"
I read this as, just using UnicodeData.txt by itself is incomplete.
I think we need to use the "Unconditional" mappings and the "Conditional
Language-Insensitive" mappings (which is just Greek sigma). Obviously,
skip the "Language-Sensitive" mappings.
