title: How to get correct character-encoding between mysql and filemaker
body: <p>I'm unsure if this is a php-, filemaker-, mysql- or an odbc driver issue. </p>
  
  <p>For security reasons the input fields of my current php webform convert special characters into hex codes, (for example: # becomes <code>&amp;#39;</code> ) This hex code is saved in the database and will also be shown in Filemaker11 as the hex code. This is not what i want. 
  How can I make sure the special character will be displayed as it should be?</p>
  
  <p>The other way round (from filemaker to db), no conversion will be done on inserting the special characters. </p>
  
  <p>How can I make sure everything will be consistent?</p>
  
  <p>Kind regards,
  Jeroen</p>