I have a "Dupe Detector" field in a couple of objects that is Unique (Case Insensitive). It is a Text(255) whose value is updated by a Workflow Field Update.
We have recently had the problem that different Ids can be identical when case insensitive, e.g. 003U000000p3nyu and 003U000000p3nyU.
Therefore we need to change this to case sensitive. But as it's a managed object, we can't.
Normally I would create a new field/workflow that is identical to the old one, but case sensitive. But then I have the problem of the old field being null and as it's unique, it would still fail.
The only solution I can think of is to put a formula like NOW() as the Default Value of the old case insensitive field, to guarantee uniqueness. But that seems like a big hack.
Is there a better way? Or has anyone had any luck contacting Salesforce to get a field changed from case insensitive to case sensitive? It wouldn't break any existing data...