# Equipment Schedule dataset binding

**URL:** <https://forum.inductiveautomation.com/t/equipment-schedule-dataset-binding/5571>\
**Category:** Ignition\
**Created:** [December 13, 2012, 9:15am UTC](https://forum.inductiveautomation.com/t/equipment-schedule-dataset-binding/5571 "2012-12-13T09:15:13Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ivan](https://avatars.discourse-cdn.com/v4/letter/i/df788c/32.png) [@Ivan](https://forum.inductiveautomation.com/u/Ivan)\
**Post date:** [December 13, 2012, 9:15am UTC](https://forum.inductiveautomation.com/t/equipment-schedule-dataset-binding/5571/1 "2012-12-13T09:15:13Z")

</div>

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?

Thanks in advance.

---

<div class="post-metadata">

**Author:** ![Ivan](https://avatars.discourse-cdn.com/v4/letter/i/df788c/32.png) [@Ivan](https://forum.inductiveautomation.com/u/Ivan)\
**Post date:** [December 13, 2012, 9:44am UTC](https://forum.inductiveautomation.com/t/equipment-schedule-dataset-binding/5571/2 "2012-12-13T09:44:59Z")

</div>

I found out that VARCHAR is working out properly but I then need to specify the color either by its name or its HEX. Is there a way I can use RGB?

---

<div class="post-metadata">

**Author:** ![Travis.Cox](https://avatars.discourse-cdn.com/v4/letter/t/b9bd4f/32.png) [@Travis.Cox](https://forum.inductiveautomation.com/u/Travis.Cox)\
**Post date:** [December 13, 2012, 6:34pm UTC](https://forum.inductiveautomation.com/t/equipment-schedule-dataset-binding/5571/3 "2012-12-13T18:34:18Z")

</div>

You should be able to use:

color(255,0,255,255)

as the string representation of a color.

---

<div class="post-metadata">

**Author:** ![Ivan](https://avatars.discourse-cdn.com/v4/letter/i/df788c/32.png) [@Ivan](https://forum.inductiveautomation.com/u/Ivan)\
**Post date:** [December 14, 2012, 1:52pm UTC](https://forum.inductiveautomation.com/t/equipment-schedule-dataset-binding/5571/4 "2012-12-14T13:52:31Z")

</div>

It works thanks!  
Is there a section in the manual concerning data type casting between mysql and ignition?

---

<div class="post-metadata">

**Author:** ![Robert.McKenzie](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/robert.mckenzie/32/4134_2.png) [@Robert.McKenzie](https://forum.inductiveautomation.com/u/Robert.McKenzie)\
**Post date:** [December 14, 2012, 7:18pm UTC](https://forum.inductiveautomation.com/t/equipment-schedule-dataset-binding/5571/5 "2012-12-14T19:18:04Z")

</div>

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.