[clug-progsig] Storing large bitwise values in MySQL
John E Jardine
john_e_jardine at spamcop.net
Wed May 23 02:27:11 PDT 2007
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.
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
> Should I use a BLOB, a _really_ big INT or go about it some completely
> different way?
> clug-progsig mailing list
> clug-progsig at clug.ca
More information about the clug-progsig