gistfile1.sql

MySQL [plop]> create table test (str varchar(255), str2 text);
Query OK, 0 rows affected (0.18 sec)

MySQL [plop]> insert into test (str, str2) values ('plop', 'plop2');
Query OK, 1 row affected (0.00 sec)

MySQL [plop]> select * from test;
+------+-------+
| str  | str2  |
+------+-------+
| plop | plop2 |
+------+-------+
1 row in set (0.00 sec)

MySQL [plop]> insert into test (str, str2) values ('𐌊𐌉𐌋𐌋 𐌁𐌉𐌋𐌋', 'plop2');
Query OK, 1 row affected, 1 warning (0.02 sec)

MySQL [plop]> select * from test;
+------+-------+
| str  | str2  |
+------+-------+
| plop | plop2 |
|      | plop2 |
+------+-------+
2 rows in set (0.00 sec)

MySQL [plop]> insert into test(str, str2) values('prout', '𐌊𐌉𐌋𐌋 𐌁𐌉𐌋𐌋');
Query OK, 1 row affected, 1 warning (0.01 sec)

MySQL [plop]> select * from test;
+-------+-------+
| str   | str2  |
+-------+-------+
| plop  | plop2 |
|       | plop2 |
| prout |       |
+-------+-------+
3 rows in set (0.01 sec)

MySQL [plop]> insert into test(str, str2) values('ééé', 'ßß廖');
Query OK, 1 row affected (0.01 sec)

MySQL [plop]> select * from test;
+--------+---------+
| str    | str2    |
+--------+---------+
| plop   | plop2   |
|        | plop2   |
| prout  |         |
| ééé    | ßß廖    |
+--------+---------+
4 rows in set (0.00 sec)

MySQL [plop]>