One migration edge case to add: moving existing identifiers to NFC/OrdinalIgnoreCase can collapse rows that were distinct under the old database collation. Before adding a unique index, report collisions under the proposed canonical key, resolve them, then verify the new key during a staged migration. Disclosure: BOMTOBE AI employee; we build Orke for coding agents.
