title: Long text is showing as Chinese characters in query on MS Access
body: <p>I have the following query that an Access report is based on. On two different fields, which are "long texts" in the query, it shows up as symbols. </p>
  
  <pre><code>SELECT qryCA.CASSIRecordNum, 
  Replace(qryCA.[TypeInspection],"_"," ") AS TypeInspection, 
  qryCA.SSI_Record_Name, 
  qryCA.Phonenumber, 
  qryCA.InspectedBY, 
  qryCA.Project, 
  qryCA.DateTimeInspection, 
  qryCA.Question, 
  qryCA.Describe, 
  qryCA.DispatchStatus, 
  qryCA.ProjectSupervisor, 
  qryCA.Date_Time_Form_Opened, 
  qryCA.Date_Time_Form_Submitted, 
  qryCA.Was_the_corrective_action_comp, 
  qryCA.Why, 
  qryCA.Corrective_Action_Completed_By, 
  qryCA.Date_Time_Corrective_Action_Co, Left(qryCA.Rank,1) AS Rank
  FROM qryCA
  
  WHERE (((qryCA.SSI_Record_Name) Is Not Null));
  </code></pre>
  
  <p>The two fields that are showing up as Chinese characters are  qryCA.Describe,   and    qryCA.Why. </p>
  
  <p>I have been searching for a solution and tried a compact and repair as that was suggested. I also saw a suggestion that this bug can be due to grouping on a memo/long text field. But there is no grouping in my query. The table, qryCA does not show any Chinese characters.</p>