In SQL, I would like to create a table which can contain generic data types. This types can change from every row. The solution I could come up to is:
CREATE TABLE TagValue ( tag VARCHAR(64), value BLOB, type INTEGER, PRIMARY KEY(tag) );
Here in the 'type' column I put the type of data contained in value.
Is there a better solution?