Field Type: Hex

Idea created by bigtom on Oct 13, 2017

    Proposing a new field type, Hex (Hexadecimal). Data keeps growing and FM continues to integrate with other systems that have widespread hexadecimal usage. Even native UUIDs are Hex. The overhead to index and manage a hex string as Text in FileMaker is costly and not necessary.


    The benefits would be increases in speed of index and search for these fields as well as smaller overall file size. Certainly it is known that other databases often do not have a Hex data type, but they do allow you to specify a character set per field.


    This would be accompanied by a function GetAsHex( ).


    Many files are using UUIDs for key fields and this would be a decent improvement in the overall performance compared to using Text while keeping the benefits of a UUID. This is not isolated to UUIDs. Hexadecimal use is widespread for many things.


    Things to talk about are how this data type would be backwards compatible with older versions.


    Alternatively it might be better to just have a Binary field type like everyone else and I think that might already be an existing idea.