Re: Problem using Mysql++ query with utf8

[Joy Zhang]

I have solved my problem: set the default character set to be 'utf8' solves the problem.

mysqlpp::Query query = conn.query();
query<<"SET NAMES 'utf8'";
query.execute();

query<<"insert into chinese_english (UserName) values ('Nürnberger')";
query.execute();

Or one can set the default character set to be 'utf8' for the mysql server to avoid setting the character set before each query