| Subject | RE: [firebird-support] Newbie question on how to hold an unusual data type |
|---|---|
| Author | Leyne, Sean |
| Post date | 2015-03-06T21:25:20Z |
Marco,
I would recommend to sacrifice disk space and to store the key as a string using a base 36 encoding (0-1 + A-Z) -- it makes debugging via tools much easier. Difference space between OCTET and base 36 encoding would only be an additional 7 characters.
Sean
> Maybe storing it into a CHAR(22) using OCTECTS charset?While this will work and is the smallest storage footprint/representation.
I would recommend to sacrifice disk space and to store the key as a string using a base 36 encoding (0-1 + A-Z) -- it makes debugging via tools much easier. Difference space between OCTET and base 36 encoding would only be an additional 7 characters.
Sean