German Umlaut "ü" etc. not showing (server-side scripting)

phalancs

Although entries with special german characters are correctly visible in the mysql database any entry with such a special character gets cut at this point.

Any help? Thanx in advance!

phalancs

This post solved it: http://datatables.net/forums/discussion/675/failed-to-search-server-side-data-utf8/p1#Item_4

IN THE SERVER_processing.php FIND:
[code]mysql_select_db( $gaSql['db'], $gaSql['link'] ) or
die( 'Could not select database '. $gaSql['db'] );
[/code]

ADD AFTER
[code]
//To send utf8 data to MySql - needed if you need to inject utf8 data for search
mysql_query("SET character_set_client=utf8", $gaSql['link']);
mysql_query("SET character_set_connection=utf8", $gaSql['link']);

//To read utf8 data from MySql - needed if your result set contains utf8 data
mysql_query("SET character_set_results=utf8", $gaSql['link']);
[/code]