switching from libmysqlclient.a to libmariadbclient.a ... leads to issue when inserting row ...
Hi, I just tried to use libmariadbclient.a instead of libmysqlclient.a in my application. Building the application is O.K. But when trying to insert a row in the mariadb database , I got following error : 1366:Incorrect string value: '\xEAt du ...' for column 'V_DESC' at row 1
Did I miss something when build the libmariadbclient.a library ? Thx for help.
J.P. Ribeauville
FYI mariadb server version is 5.5.68
Here are character_set values in the server
show variables like "%character%";
+--------------------------+----------------------------+
| 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 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
Answer Answered by jean-pierre RIBEAUVILLE in this comment.
Hi, It works now !! By adding these lines in [mysqld] section in Mariadb server configuration file :
character-set-client-handshake = FALSE character-set-server = utf8 character-set-server = latin1
HTH.
