Configuring C connector to accept ASCII characters to insert in an UTF8 database
Hi, When trying to do such thing ( insert an ê (0XEA ascii value), I got following error :
.... Arrêt du serveur de production')' (1366:Incorrect string value: '\xEAt .....
My database character-set is utf8 :
+--------------------------+-----------------+
| Variable_name | Value |
+--------------------------+-----------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| collation_connection | utf8_general_ci |
| collation_database | utf8_general_ci |
| collation_server | utf8_general_ci |
+--------------------------+-----------------+
How may I achieve this insertion by using a mariadb C connector?
By using a mysqlclient , it works.
Any help is welcome. Thx
J.P.
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
