RE: Best design for a table using variant data

inal Message- From: Carsten Pedersen [mailto:cars...@bitbybit.dk] Sent: Friday, August 10, 2012 15:33 To: Gaston Gloesener Cc: mysql@lists.mysql.com Subject: Re: Best design for a table using variant data You don't specify how many different types (including min/max values) you expect to be using. I

Best design for a table using variant data

Hello, I am currently facing a design where a table (virtually) needs to store attributes of a topic (related table). The attributes can be user defined, i.e. not known at development type and depend on other factors. Each attributes value can be one of different types (int, int64, double, stri