I have a collection of HEX values, which are 36 characters long I need to store efficently in a database.
My problem is I dont know what to use. If I use VARCHAR(36) then it seems to waste a lot of space. If I store it as Blobs I cant index the values.
The table has 2 coloums, one being a bigint with autonumbering, and the other being the field with the Hex values in.
Any suggestions that I can use to optimise my table would be appriciated.