The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-15. For the latest, interactive version please visit https://mariadb.com/kb/.

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.

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.