Re: Extent 2: passing string to database with utf8 encoding results in invalid chars

[Sven Bisaro]

Hi Frankie,

here is the information you asked for:

1) Show full columns:

mysql> show full columns from tbl_monkey;
+--------------+------------------+-----------------+------+-----+---------+----------------+---------------------------------+----
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Com
+--------------+------------------+-----------------+------+-----+---------+----------------+---------------------------------+----
| pk_monkey_id | int(10) unsigned | NULL | | PRI | NULL | auto_increment | select,insert,update,references |
| monkey_name | varchar(255) | utf8_general_ci | YES | | NULL | | select,insert,update,references |
+--------------+------------------+-----------------+------+-----+---------+----------------+---------------------------------+----
2 rows in set (0.00 sec)

2) I use the "MySql Command Line Client" to check the inserted data with the command:

mysql> select * from tbl_monkey;

Thanks,
Sven