title: Mysql query return BLOB with Union Join
body: <p>When I run a Union query in mysql some values return as BLOB, is there a way to fix this?
  I union the query because i want the sum of  specific columns to be at the bottom</p>
  
  <pre><code>select a.app_file_id,a.app_trn,a.app_fname,a.app_lname,l.computer_interest,l.loan_life,l.app_ln_amnt, l.commit_date,l.app_amnt_owed,r.amount_paid
  from applicant a
  left join loan l on   l.l_app_file_id=a.app_file_id
  left join receipt r on r.r_app_file_id=l.l_app_file_id
  WHERE l.app_loan_type=r.receipt_loan_type
  AND l.app_loan_type='Computer Loan'
  AND  MONTHNAME(commit_date) = 'April'
  and YEAR(commit_date)=2012
  
  Union
  Select '', '','','','','',SUM(l.app_ln_amnt),'',SUM(l.app_amnt_owed),SUM(r.amount_paid)
  from applicant a
  left join loan l on   l.l_app_file_id=a.app_file_id
  left join receipt r on r.r_app_file_id=l.l_app_file_id
  WHERE l.app_loan_type=r.receipt_loan_type
  AND l.app_loan_type='Computer Loan'
  AND  MONTHNAME(commit_date) = 'April'
  and YEAR(commit_date)=2012
  </code></pre>