0

I want to store a 512 bit data in mysql.

I'm wondering if it is better to store it as char(64) or 8 columns of bigint or something else?

My priority is to maximize the speed of comparison (I am ok to have slow updates, inserts, deletes in exchange for a faster comparison speed)

(I am aware simply storing it as char(64) will probably take the least development time, however although that's very important, it's currently ranked last in my set of priorities)

Paul Sonier
  • 38,903
  • 3
  • 77
  • 117
Matt
  • 1
  • http://stackoverflow.com/questions/2028949/mysql-ideal-field-type-for-fixed-width-binary-data – ben Jul 05 '11 at 21:12

2 Answers2

1

Prepare your downvotes, I've just read some Daily WTF, so this is going to be a bit crazy answer...

Store however you like (char, bigints..) but also add a hashed(md5? part of md5?) value, then after select, filter out false positives.

Karoly Horvath
  • 94,607
  • 11
  • 117
  • 176
0

you probably should not use char; character types apply encoding rules to the data, which make perfect sense when the data is text, but don't work at all for binary data. you should use binary

SingleNegationElimination
  • 151,563
  • 33
  • 264
  • 304