Is it possible to have mixed case text keys in FM?

The reason for asking is that I have to import leads with unique identifiers like

record1: 00Q00000001gBVC

record2: 00Q00000001gBVc

Sometimes it would be helpful to use this key to exclude duplicates on import etc.

Is there a way to make this a unique key in FM or make a calculation on this field that will be unique?

quote:

---

Originally posted by AndriesV:

Is it possible to have mixed case text keys in FM?

The reason for asking is that I have to import leads with unique identifiers like

record1: 00Q00000001gBVC

record2: 00Q00000001gBVc

Sometimes it would be helpful to use this key to exclude duplicates on import etc.

---

Do you mean that you want the above to be treated as DIFFERENT values based on the fact that the case is different? Or are you asking if Filemaker will treat them differently?

While I have not tested this, I would assume that if you set indexing to ASCII it should work, as C and c have different ASCII values.

quote:

---

Is there a way to make this a unique key in FM or make a calculation on this field that will be unique?

---

See my article at: http://www.fmforums.com/cgi-bin/ultimatebb.cgi?ubb=get_topic;f=8;t=000018;p=

If you want upper case to be distinct from lower case when searching or in key fields for relationships, you have to set the indexing mode to ASCII (under Storage Options in the define fields dialog), otherwise "CAT" and "cat" will be treated as the same thing.

Didn't know, so I just tested it.

Thanks a lot, just what I was looking for.

Couldn't find it in the help files.