How to use BIGINT or runtime defined sets with more than 32
Posted: Wed Nov 19, 2003 9:03 am
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?
use CHAR in MYSQL:
simle PHP coding and data write but
MySQL WHERE clauses will not work on this field
use SET in MySQL:
good for MySQL but
complicated in PHP
Any experiences in this area?
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?
Any experiences in this area?