We have upgraded MySQL from 5.1 to 5.5 and now when we extract the data what was previously showing as yes/no is now showing as 1/null, in addition the first row of data is showing the correct yes/no values.
This seems only to be affecting custom fields which used the inbuilt yes/no radio field type.
Where we had custom alphanumeric fields, type radio, yes/no value options - the data is fine. So a fix could be to reset up all the fields affected as alphanumeric, re-import the data and then delete the old fields - but this will no resolve the underlying issue. Concerned if we do this it might come back to bite us later.
Any pointers appreciated.