I’d like to bind the Scheduled Events dataset to a MySQL table.
Which datatype do I set for the color columns (Foreground, Background, LeadColor) in my table?
Which datatype do I set for the ItemId, which is shown as “Object” in the dataset? INT would do?
Unfortunately there is not. The only real issues are the odd types like color, border, etc. Everything else should come across just fine, and if it doesn’t, then take a look at the expression functions’ string to X conversions.