Can't insert some special characters into mysql
<p>The value cut off after that character  </p>

<p>Why this happening?</p>

<pre><code>create table tmp2(t1 varchar(100)); 

insert into tmp2 values('beforeafter'); 

mysql&gt; select * from tmp2; 
+--------+ 
| t1 | 
+--------+ 
| before | 
+--------+ 
1 row in set (0.01 sec)
</code></pre>

<p>I ran followed commands and returned some useful information</p>

<pre><code>mysql&gt; SHOW FULL COLUMNS FROM tmp2;
+-------+--------------+-----------------+------+-----+---------+-------+---------------------------------+---------+
| Field | Type         | Collation       | Null | Key | Default | Extra | Privileges                      | Comment |
+-------+--------------+-----------------+------+-----+---------+-------+---------------------------------+---------+
| t1    | varchar(100) | utf8_general_ci | YES  |     | NULL    |       | select,insert,update,references |         |
+-------+--------------+-----------------+------+-----+---------+-------+---------------------------------+---------+
1 row in set (0.00 sec)
</code></pre>

<p>and this,</p>

<pre><code>mysql&gt; SELECT character_set_name FROM information_schema.`COLUMNS` WHERE table_schema = "test" AND table_name = "tmp2" AND column_name = "t1";
+--------------------+
| character_set_name |
+--------------------+
| utf8               |
+--------------------+
1 row in set (0.00 sec)
</code></pre>

<p>Im testing this on ubuntu/mysql command line.</p>