Configuring C connector to accept ASCII characters to insert in an UTF8 database
You are viewing an old version of this question. View
the current version here.
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.
Comments
No comments
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.
