title: Trouble with GROUP_CONCAT and Longtext in MySQL
body: <p>The SQL...</p>
  
  <pre><code>UPDATE Threads t 
  SET t.Content = (
      SELECT GROUP_CONCAT(a.Content ORDER BY a.PageID SEPARATOR '&lt;!-- pagebreak --&gt;') 
      FROM MSarticlepages a
      WHERE a.ArticleID = t.MSthreadID GROUP BY a.ArticleID
  )
  </code></pre>
  
  <p>As you can see it takes all of an article's pages (which are each
  stored as longtext in separate rows) and GROUP_CONCATs them into a
  single longtext row. The problem is the results are only so many
  characters and then it gets completely truncated, losing about 90% of
  the contents. Does CONCAT not handle longtext very well or is there
  something else I am doing wrong?</p>