Charsets, Gtkmm and MySQL

[Bernd Robertz <bernd robertz cssweb de>]

Hello list,

I'm not really sure, but I hope My question is in the right place here.

I wrote a simple database app like this:

Connect to a MySQL server via libmysql++,
and then list the rows in a treeview.
Doubleclick on a row shows a window with some entries and a textview
with the content of the selected row.
The textview is associated with a type text in the DB.

Everything is fine.

So but I ran really into problems with the charsets.
german umlaute (ö, ä, etc.) and some other characters are glyphs in the
treeview. Ok, thats not the main problem.

That is: The entries in the detailed view still shows the glyphs for
some chars like ö, ä.
But on some rows, the represented textbuffer for textview is not
visible. Wich means the textview is in some rows empty.

I run My app from a console and I got these error messages:

:::::::::
Gtk-CRITICAL **: gtk_text_buffer_emit_insert: assertion `g_utf8_validate
(text, len, NULL)' failed
:::::::::

In other rows, the textbuffer is correct shown, exepct some glyphs.

If I print the textbuffer as a simple .c_str() in a console it will be
shown correctly (inklusive ä, ö, ü...).
(Tried to show the textview as a .c_str(), without any effect.)

The SQL connection is serverside-configured as UTF-8 Unicode.
The SQL table collation is UTF-8 General CI (Case Insensitive).
The Application runs on a DE_de Euro (ISO-8859-15).

All characters are shown correctly in a PHP app wich does the same, just
only online. :-)

I hope someone could turn on a light above my head, why I don't get the
right charactes.

Thanks alot in advance

Bernd