[Zope-DB] unlimited SET?

[3205 5361 1215 9784]

Hello zope-db,

      there is this SET type in mysql... the problem is it's binary
      based, and can contain up to 32 elements...

      what if i have lot more stuff?

      i have 2 tables, the first one is for the product (i'm building
      an e-commerce site) and the other has options, that can be
      selected for the product.

      i thought of keeping the "option1,option2,option3" structure,
      but make it TEXT instead of SET, and doing the whole
      searching/adding/deleting logic from code and not mysql.

      but it seems a bit complicated for the first.

      is there a better workaround? whats the practice for this?


      i have ran into this problem several times, and i am sure there
      is a good working practice for this under zope;D


      thanks a lot,

      k.

-- 
don't believe everything you think