Codeigniter not accepting "utf8mb4" as default charset

Question

Good day,

I am using Codeigniter to develop my webapp. PHP version on the server is 5.6.22 and Mysql version of the db is 5.6.27. In codeigniter's database.php when I change the charset to "utf8mb4" from "utf8", I get the following message .(image attached)

Unable to set client connection character set: utf8mb4

UPDATE I can run the codeigniter app on another server that has the same php version and the same mysql version. So it must be something pertaining to httpd.conf or php.ini, maybe?

did your change the charset of your database in actual. To do so Please read this https://mathiasbynens.be/notes/mysql-utf8mb4 — Pradeep, Jul 14 '16 at 13:13

score 6 · Answer 1 · edited May 23 '17 at 12:22

6

In database.php

Set char_set to utf8mb4 and dbcollat to utf8mb4_unicode_ci or utf8_general_ci

I tested this with my Codeigniter 3.0

$db['default'] = array(
    'dbdriver' => 'mysqli',
    'dbprefix' => '',
    'pconnect' => FALSE,
    'db_debug' => (ENVIRONMENT !== 'production'),
    'cache_on' => FALSE,
    'cachedir' => '',
    'char_set' => 'utf8mb4',
    'dbcollat' => 'utf8mb4_unicode_ci',

);

And in controller I add this

$CI = &get_instance();
$CI->load->database();
echo $CI->db->char_set;
echo "<br>";
echo $CI->db->dbcollat;

Output

utf8mb4
utf8mb4_unicode_ci

Read this

Using utf8mb4 with php and mysql

edited May 23 '17 at 12:22

Community

1
1

answered Jul 14 '16 at 13:28

Abdulla Nilam

36,589
17
64
85

as i know there are nothing with the `php.ini` or `my.ini`(mysql) – Abdulla Nilam Jul 15 '16 at 11:57
Please see my updated question. Also I cannot test this in controller as it does not allow me to load view. Just give me the error as in screenshot. – Waris Ali Jul 15 '16 at 11:59
@WarisAli are you still facung this issue?? – Abdulla Nilam Jul 19 '16 at 01:43
No. Turns out although php5.5+ support utf8mb4, there are some versions that have some known issues with the char encoding of the type. I unistalled and installed the latest php and the error was gone. It was strange. – Waris Ali Jul 19 '16 at 06:52
@WarisAli I'm using php 7. That's what i inform you early – Abdulla Nilam Jul 19 '16 at 09:22

score 0 · Accepted Answer · answered Jul 19 '16 at 06:52

0

I was able to remove the bug by removing my php installation and installing the httpd and php again from scratch.

answered Jul 19 '16 at 06:52

Waris Ali

522
3
14

Codeigniter not accepting "utf8mb4" as default charset

2 Answers2