Sunday, November 21, 2004

SET datatype for Database

I always thought that data types of columns in a database table could only be primitive values, like Integer, String, Blob etc. Well, as it turns out most databases also support a Set datatype. Basically a column of Set datatype can equal a variable number of pre defined values(up to 64, but depends on DB vendor). Thus, instead of having N boolean-type columns in a table, one can use a set. Cool !

0 Comments:

Post a Comment

<< Home