[clug-progsig] Storing large bitwise values in MySQL

[John E Jardine]

Ok - with the disclaimer that this is pure theory...

If you don't need every country in the world, you could use a 'SET' -
but it has a maximum of 64 entries.

If you need more than this I think you'll have to either dummy something
up yourself or, as Shawn suggested, create a table of countries and a
table that contains rows identifying the intersection of countries and
each row of the current table.

Cheers,
J.J.

On Tue, 2007-05-22 at 16:56 -0600, Nick Wiltshire wrote:
> Hi all,
> 
> this might not even be the correct way to go about it, but I need to store a 
> multiple-select value with the possible choices being the countries of the 
> world.
> 
> Should I use a BLOB, a _really_ big INT or go about it some completely 
> different way?
> 
> Nick
> 
> _______________________________________________
> clug-progsig mailing list
> clug-progsig at clug.ca
> http://clug.ca/mailman/listinfo/clug-progsig_clug.ca