mysqlpp and wchar_t problem

gani · #1 (**permalink**) 09-28-06, 06:03

hi..
i have a problem using Query class from mysqlpp with wchar_t.
i want to insert unicode.

Code:

	mysqlpp::Connection con( "test", "localhost",  "test", "" );
	mysqlpp::Query query = con.query();
	char *		test = "abcdefghij";
	wchar_t *	wtest = L"abcdefghij";

	query << "INSERT INTO tes VALUES( '" << test << "')";
	query.execute();

	query << "INSERT INTO tes VALUES( '" << wtest << "')";
	query.execute();

the char test will gave the right result, 'abcdefghij' inserted to db.
but the wchar_t wtest not give the right result, the record filled with '004A00F4'.

it seems Query not welcome unicode.
so how can I insert unicode using mysqlpp??

thx.