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_nameValue

+--------------------------+----------------------------+

character_set_clientutf8
character_set_connectionutf8
character_set_databaseutf8
character_set_filesystembinary
character_set_resultsutf8
character_set_serverutf8
character_set_systemutf8
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.

Comments

Comments loading...
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.