Best way to store 32 byte binary value with ability to index

Matthew Jew mjew at icnc.com
Thu Jul 6 16:19:05 CDT 2006


Hello,

My application has a need to store 32 byte binary values, which I was  
planning to
store in a FixedBinary field.

However, in a recent post it was mentioned that one could use a  
FixedBinary field
to store values that "you do not need to index".

Does that mean that I cannot index (and therefore cannot quickly  
search on) a FixedBinary field?

If that is true, what is the best way to store this 32 byte binary  
value so that I might
quickly locate records?

- Matthew



More information about the Valentina mailing list