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

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
tsajuk
Forum Newbie
Posts: 1
Joined: Wed Nov 19, 2003 9:03 am

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

Post 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?
Post Reply