multilingual support for databases inserts

[eluser]PhilTem[/eluser]
From the error you dumped in the OP it looks like the values you're trying to insert create apostrophes which screw the query.

Try

Code:

$query = "INSERT INTO `bf_departments` (`department_name`, `date_created`, `deleted`) VALUES('" . mysql_real_escape_string($department_name) . "', NOW(), '0');

On another hand: What is the char-set you're using for the connection (have a look at $db['default']['char_set'] = 'utf8' and what's the char-set of your table? Might be a problem there.