title: About string datatype in vb.net
body: <p>I have a <code>String</code> variable in VB.NET and it contains a value like </p>
  
  <pre><code>"Date of    9/23/2012  Tot Sec_sale Amt = 29,22,696RM's Wise  ,  Gunadeep=15,83,876 ,  Purushothaman C.S.=1,12,829 ,  P.madhusudhanreddy=4,63,933 ,  Sunil vakayil=6,31,120 ,  Girish Varghese=33,019 ,  Debarun Chakraborty=79,288 ,  Rajiv Varma=18,630, RM's DT Count 1,342"
  </code></pre>
  
  <p>In application side I am able to view this value. I stored this value in MySQL table column. That column contains a <code>longtext</code> datatype. But I am not able to view the full content. Not able to view the last part <code>RM's DT Count 1,342</code>. It shows like <code>Rm's...</code>.</p>
  
  <p>My table structure:</p>
  
  <pre><code>fld_msg longtext
  fld_phone   varchar(20)
  fld_date    date
  fld_status  varchar(45)
  fld_type    varchar(45)
  fld_name    varchar(50)
  </code></pre>
  
  <p>My VB.NET code:</p>
  
  <pre class="lang-vb prettyprint-override"><code>Dim bh_msg As String =
      "Date of    " + Convert.ToDateTime(txt1.Text).Date +
      "  Tot Sec_sale Amt = " + strdmy_bh_sec_amt.ToString +
      "RM's Wise " + bh_amt_frmt1.ToString + "," +
      " RM's DT Count " + str_bh_dt_count.ToString
  </code></pre>