Switching from mysqlclient to libmysqlclient to libmariadbclient.a ... 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
Answer Answered by jean-pierre RIBEAUVILLE in this comment.
Hi, After being able to find ths this explanation : The last line (skip-character-set-client-handshake) skips the requirement of executing SET NAMES/SET CHARACTER SET directives upon connection and makes all three default encoding settings character_set_client, character_set_database and character_set_connection consistent.
Issue is solved by adding , in mariadb .cnf file under [mysqld]
skip-character-set-client-handshake
HTH . J.P.
