Handling special characters in MySQL

[eluser]swissbastian[/eluser]
Hi there

I'm new to CodeIgniter and am trying to develop my first project with this framework. I use German language and therefore I need some special characters (umlauts). Using scaffolding works perfect, but umlauts are put into the database in some crypted form. If I put information directly to the database (e.g. with phpMyAdmin), CI isn't able to display umlauts correctly.

It's a MySQL database, the collation is set to utf-8 as it is configured in the config.php file, too.

I thought with utf-8 I shouldn't have any problem with different character sets. Well, I'm not expert in this special case. Anyone have a solution?

Thanks

Bastian

[eluser]tobben[/eluser]
Do a...

Code:

$this->db->query("SET NAMES 'utf8'");