Page 1 of 1

How to use BIGINT or runtime defined sets with more than 32

Posted: Wed Nov 19, 2003 9:03 am
by tsajuk
Has someone already found a way to implement sets with more than 32 Members?
We are storing values of differen sets in one MySQL table. Our first try was to use a BIGINT field. All set operations work well with the bitwise logical operations. However here seems no way to handle a MySQL BIGINT (64 bit) in PHP - the value will always get muddled up into a float if it exceeds 31 bits.
What's the best way?
:arrow: use CHAR in MYSQL: :) simle PHP coding and data write but :( MySQL WHERE clauses will not work on this field
:arrow: use SET in MySQL: :) good for MySQL but :( complicated in PHP

Any experiences in this area?