Here is the database information
+--------------------+---------+--------------------+
| database | charset | collation |
+--------------------+---------+--------------------+
| information_schema | utf8 | utf8_general_ci |
| mysql | utf8mb4 | utf8mb4_general_ci |
| performance_schema | utf8 | utf8_general_ci |
| sys | utf8 | utf8_general_ci |
| ubb756 | utf8mb4 | utf8mb4_general_ci |
+--------------------+---------+--------------------+
5 rows in set (0.00 sec)

and the table information
SHOW FULL COLUMNS FROM ubbt_POSTS;
+-----------------------+------------------+--------------------+------+-----+---------+----------------+----------
| Field | Type | Collation | Null | Key | Default | Extra | Privilege
+-----------------------+------------------+--------------------+------+-----+---------+----------------+----------
| POST_ID | int(11) unsigned | NULL | NO | PRI | NULL | auto_increment | select,in
| POST_PARENT_ID | int(11) unsigned | NULL | NO | MUL | NULL | | select,in
| TOPIC_ID | int(11) unsigned | NULL | NO | MUL | NULL | | select,in
| POST_IS_TOPIC | tinyint(1) | NULL | NO | | 0 | | select,in
| POST_POSTED_TIME | int(11) unsigned | NULL | NO | MUL | NULL | | select,in
| POST_POSTER_IP | varchar(60) | utf8mb4_general_ci | YES | | NULL | | select,in
| POST_SUBJECT | text | utf8mb4_general_ci | YES | MUL | NULL | | select,in
| POST_BODY | text | utf8mb4_general_ci | YES | | NULL | | select,in
| POST_DEFAULT_BODY | text | utf8mb4_general_ci | YES | | NULL | | select,in
| POST_IS_APPROVED | tinyint(1) | NULL | NO | MUL | 1 | | select,in
| POST_ICON | varchar(30) | utf8mb4_general_ci | YES | | NULL | | select,in
| POST_IS_MEMBER_POST | tinyint(1) | NULL | YES | | 1 | | select,in
| POST_HAS_POLL | tinyint(1) | NULL | YES | | NULL | | select,in
| POST_HAS_FILE | tinyint(1) | NULL | YES | | NULL | | select,in
| POST_MARKUP_TYPE | varchar(10) | utf8mb4_general_ci | YES | | markup | | select,in
| POST_LAST_EDITED_TIME | int(11) | NULL | YES | | NULL | | select,in
| POST_LAST_EDITED_BY | varchar(64) | utf8mb4_general_ci | YES | | NULL | | select,in
| POST_LAST_EDIT_REASON | varchar(255) | utf8mb4_general_ci | YES | | NULL | | select,in
| USER_ID | int(9) unsigned | NULL | NO | MUL | NULL | | select,in
| POST_PARENT_USER_ID | int(9) unsigned | NULL | NO | | 0 | | select,in
| POST_ADD_SIGNATURE | int(1) | NULL | NO | | 0 | | select,in
| POST_POSTER_NAME | varchar(50) | utf8mb4_general_ci | YES | | NULL | | select,in
| POST_MD5 | varchar(32) | utf8mb4_general_ci | YES | MUL | NULL | | select,in
+-----------------------+------------------+--------------------+------+-----+---------+----------------+----------
23 rows in set (0.00 sec)