Answers.Body: <p>I did made a test against Civicrm 4.6.10 against Mysql version 5.6.30</p>
  
  <p>where I did created two custom field with option as below </p>
  
  <ol>
  <li>custom alphanumeric fields, type radio, yes/no value options</li>
  <li>custom Integer fields, type radio, 1/2 value options</li>
  </ol>
  
  <p>Both gets saved against database as excepted first one with alphanumeric got saved as yes/no and other one got saved as 1/2</p>
  
  <p>So I would recommend you to create a new custom field with alphanumeric and try importing the records again which should import correctly.</p>
  
  <p>I guess this helps!!!</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-08-31T16:00:32.923Z
Answers.LastActivityDate: 2016-08-31T16:00:32.923Z
Answers.UserDisplayName: Ramesh - ARTECH Consultancy
Body: <p>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.  </p>
  
  <p><a href="https://i.sstatic.net/4doT2.jpg" rel="nofollow noreferrer"><img src="https://i.sstatic.net/4doT2.jpg" alt="enter image description here"></a></p>
  
  <p>This seems only to be affecting custom fields which used the inbuilt yes/no radio field type.</p>
  
  <p>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.</p>
  
  <p>Any pointers appreciated.</p>
  
Tags: <custom-fields><mysql>
Title: mySQL 5.1 to 5.5 upgrade - radio button data error
ThreadText: # mySQL 5.1 to 5.5 upgrade - radio button data error
  
  (Asked by: username_0 on 2016-08-31)
  
  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.
  
  [![enter image description here](https://i.sstatic.net/4doT2.jpg)](https://i.sstatic.net/4doT2.jpg)
  
  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.
  
  **Tags:** custom-fields, mysql
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2016-08-31. Score: 1
  
  I did made a test against Civicrm 4.6.10 against Mysql version 5.6.30
  
  where I did created two custom field with option as below
  
  1. custom alphanumeric fields, type radio, yes/no value options
  2. custom Integer fields, type radio, 1/2 value options
  
  Both gets saved against database as excepted first one with alphanumeric got saved as yes/no and other one got saved as 1/2
  
  So I would recommend you to create a new custom field with alphanumeric and try importing the records again which should import correctly.
  
  I guess this helps!!!
  
  
  ---
  
  