I have a DB in MySQL where a column of my table is a boolean:
`eligibilityDate` tinyint(1) NOT NULL
Data arrive from my iOS Swift app through the following functions:
let postParams = "action=save_report&id_fish=\(Reporting.fishId)&fish_name=\(Reporting.fishName)&detectedSize=\(Reporting.detectedSize)&eligibilitySize=\(Reporting.eligibilitySize)&eligibilityDate=\(Reporting.eligibilityDate)&origin=\(Reporting.origin)&production=\(Reporting.production)&townReport=\(Reporting.townReport)"
request.HTTPBody = postParams.dataUsingEncoding(NSUTF8StringEncoding)
where I guess that Bool variables eligibilityDate and eligibilitySize are converted from true/false to 'true'/'false'.
Anyway it seems that 'true' value is saved as 0 in MySQL...why? which is the correct way?
UPDATE
A possible solution could be this:
let postParams = "action=save_report&id_fish=\(Reporting.fishId)&fish_name=\(Reporting.fishName)&detectedSize=\(Reporting.detectedSize)&eligibilitySize=\(Reporting.eligibilitySize ? 1 : 0)&eligibilityDate=\(Reporting.eligibilityDate ? 1 : 0)&origin=\(Reporting.origin)&production=\(Reporting.production)&townReport=\(Reporting.townReport)"