What is the best way to handle SET fields from MYSQL using MyDAC?
Both for reading and writing. For example I want to check if a value is selected/checked in a specific record in a field SET.
MyDAC lets working with SET and ENUM fields like with usual string fields. To get list of accepted values for a SET/ENUM field, use the TCustomMyDataSet.GetFieldEnum method.
Probably, the best way is to avoid using SET and ENUM types, and use lookup tables instead.