Hi,

I just realised that brighthouse doesnt seem to support enum-columns.:

mysql> create table test (tc1 enum(‘a’,‘b’) null );
ERROR 8 (HY000): Unsupported data type.

What other datatypes are not supported? Does this include SET, too?
What about other string / numeric data types, types of the spatial extension?

CVH

Hi Chris,

The data types supported by Infobright can be found in the wiki here:

http://www.infobright.org/wiki/Supported_Data_Types_and_Values/

Regards,

Hi Chris,

From performance perspective, enum may be emulated by varchar(...) comment ‘lookup’ . It stores varchar values in dictionary and internally uses numbers.
But you cannot check validity of input values in this way.

Best regards,

Thanks Jakub,

Exactly what I wanted to know. Thanx

Chris