Re: UTF-16 on Linux Workbench - how?

[Al B]

I think that if Workbench has a bug with displaying UTF-16, then this bug should have many times reported already. Maybe I incorrectly insert the UTF-16 strings? I insert them as follows:

-------

char* szQuery = new char[ qlen ];
memset( szQuery, 0, qlen );
char* qend = szQuery;
char16_t test = {61, 1060};

qend += sprintf( szQuery, "INSERT INTO main (UCS2Field) VALUES('");

qend += mysql_real_escape_string( m_conn, qend, (char*)test, 4 );
*qend++='\'';

-------

In this case the char16's (61, 1040) are stored in database in LE mode:

0x3D 0x00 0x24 0x04

I tried to convert them to BE mode before inserting, but neither variant is displayed correctly. Maybe one need to insert the strings in some other way?