title: MySQL varchar column on group_concat shows as text in View
body: <p>I have column in base table as <code>acct_num varchar(25)</code> and I am creating a View and <code>GROUP_CONCAT()</code> is set to this column. This is shown as <code>text</code> datatype in show create view. Is it possible to have <code>VARCHAR(25)</code> datatype for <code>GROUP_CONCAT(acct_num)</code> column. Please advise.</p>
  
  <p>What I learnt from MySQL reference:</p>
  
  <blockquote>
    <ul>
    <li>I though to cast as varchar(25) but CAST can be applied as CHAR not as VARCHAR</li>
    <li>There is option to set GLOBAL_SET_GROUP_CONCAT_VALUE = 512 so that you can get output of GROUP_CONCAT() as varchar() - but it didn't work
    out for me.</li>
    </ul>
  </blockquote>