check and boolean field on mysql database

I want to use a check in the app and if the check is active i want to store in the database in a field boolean 1 if not 0.

I can store datas like text and numbers in mysql database using pure vida tutorial.

Is there any tutorial for this?

-- 

Store a number or text instead.Why bother if you know how to make a workable solution?
Anyway, BOOL is the datatype in MySQL for booleans.

-- 

how to store a text for example yes of checkbox is checked and store not if checkbox is not active?

--

if Checkbox.Checked 

then set global myText to "yes"

else set global myText to "no"

--