CI with MySQL client library 4.1.11 bug, mysql_set_charset does not exist resulting in blank pages

[eluser]Michael Brooks[/eluser]
I think there is a bug in the mysql_driver.php file.

On my server, I was finding that when I loaded the database I got nothing but blank pages. Eventually, I pinpointed the problem to line 150 in mysql_driver.php, within the db_set_charset() method:

Code:

return @mysql_set_charset($charset, $this->conn_id);

The error suppression was hiding the fact that mysql_set_charset() is not defined.

According to documentation in the db_set_charset() method, the mysql_set_charset() function is used when PHP >= 5.2.3 and MySQL >= 5.0.7. When these conditions aren't met it falls back to SET NAMES.

My server is using MySQL server version 5.0.45 and PHP 5.2.4, so it passes this test. However, it is using version 4.1.11 of the MySQL client library, which doesn't support mysql_set_charset(). I found this information here: http://www.php.net/manual/en/function.my....php#80997