Re: Problems setting connection charset

[Leszek koltunski]

Ok, I managed to make some - questionable - progress.

I managed to replace the "SET NAMES" and "SET CHARACTER SET" queries with a call to mysql_set_character_set() function :

//////////////////////////////////////////////////////////////////////////////////////
if( ! mysql_set_character_set( node->front_db, "utf8" ) )
printf("Success\n");

printf("Connection charset: %s\n", mysql_character_set_name(node->front_db) );
//////////////////////////////////////////////////////////////////////////////////////


Now, that prints "utf8" as desired ( before I couldn't link my app with a call to this function, now I've included the 'mysqlclient.lib' library and things build. BTW, why is this particular function all of the sudden in 'mysqlclient.lib' rather than 'libmysql.h' ? )

However, in terms of functionality, things on only got worse: now it completely eats up all Chinese characters I insert to the DB: ( VC++ code )

//////////////////////////////////////////////////////////////////////////////////////
CString cmd = "UPDATE products SET NAME= \'ABC <here some chinese stuff> DEF \' ";

int len = cmd.GetLength();
char* command = (char*) malloc( 2*len+1 );
int real_len = mysql_real_escape_string( db, command, cmd, len );

int ret = mysql_real_query( db, command , real_len );

if( ret != 0 ) { /* handle errors ... */ }

free( command );
//////////////////////////////////////////////////////////////////////////////////////

Now, a "SELECT NAME FROM products" issued from CLI retrieves

ABCDEF

and all the Chinese stuff in between is gone ???

Leszek