title: MYSQL CONCAT MAX LENGTH
body: <p>Following this post: <a href="https://stackoverflow.com/questions/20775370/mysql-convert-few-columns-into-one-row/20775383?noredirect=1#20775383">POST ABOUT CONCAT</a>
  My problem is that i have many rows <code>CONCAT</code> into one row. For example if i have 10 rows with string around 50 chars, my query will show me only 6-7 of that rows or something like that.
  I searech in stack and google and i found that i can change CONCAT max length by command: <code>SET group_concat_max_len := @@max_allowed_packet</code>. What i am doing wrong?</p>
  
  <p><strong>EDIT:</strong>
  When i <code>SHOW VARIABLES LIKE 'group_concat_max_len'</code> it's shows me 1024.
  Mysql version   5.0.96-log. Tables type: MyISAM. Looks like it dont have any limits, i try to select simple varchar with 2000 chars, and it looks fine.
  I have 3 tables: 1st - Item with ItemID, 2nd - Descriptionpack with ItemID and DescriptionID, 3rd Description with DescriptionID.</p>
  
  <pre><code>Select
  DISTINCT Item.ItemID as item
  ,GROUP_CONCAT(Description.DescriptionID) AS description
  From Item 
  LEFT OUTER JOIN descriptionpack
  on Item.ItemID=descriptionpack.ItemID
  LEFT OUTER JOIN description
  on descriptionpack.descriptionID=description.descriptionID
  GROUP BY item
  </code></pre>
  
  <p><strong>EDIT2:</strong> I think i found the problem, i said my problem to my provider and they answer me this: </p>
  
  <blockquote>
    <p>I reviewed your question with our hosting team. You wouldn't be able
    to change the global settings for that and other variables. However,
    you should be able to set that variable on a per session basis by
    setting it first, before other queries. Hope that helps. </p>
  </blockquote>
  
  <p>So now the problem is, how to do that.</p>