TRUNK-94 the global_property.property column was changed from a varchar to varbinary in order to support case sensitive searching.
This brought about some undesirable effects:
- varbinary is mysql specific
- varbinary columns show up strangely/inconveniently in db editors
- keys like "restModule" and "restmodule" are treated differently, even though they should be the same.
Convert this column back to a varchar. Make sure all inserts/updates/fetches on the column treat the column as case insensitive. (I believe the original reason for the ticket was that inserts were case sensitive but fetches were not)
DO NOT change the case of keys as they are being entered. We want the case to be preserved.