cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrus Adamchik <and...@objectstyle.org>
Subject Re: SET Datatype
Date Wed, 02 Feb 2011 13:20:07 GMT
Haven't tried it, but I think SQLTemplate should handle it.

Andrus

On Feb 2, 2011, at 5:21 AM, Jepse wrote:

> 
> 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.
> 


Mime
View raw message