Hi, is anybody familiar with the Mysql Datatype "Set"? http://dev.mysql.com/tech-resources/articles/mysql-set-datatype.html
For some reason we stores Boolean values fields for flags in couple tables. But with a huge entry size, we ran into the problem, that these flags are not indexable. So we thought about moving to Bitmasks. This solution is 100% indexable, but hard to use with cayenne. Does anybody knows how to select Fields like following sql query? SELECT * FROM set_test WHERE myset & 2; Thanks Philippe -- View this message in context: http://cayenne.195.n3.nabble.com/SET-Datatype-tp2404337p2404337.html Sent from the Cayenne - User mailing list archive at Nabble.com.
