Login

03-18-2014, 08:52 PM

[eluser]samus535[/eluser]
Hi Everyone,
I'm really sorry to ask this to you but I've been looking over the net for a couple of hours and tried a couple of solution but nothing seems to work...

My problem is that I have some accented characters stored in my database and when I display them on my web page they doesn't show properly...

I've tried to :

Code:
1-

mysqldump the tables and the data (while in latin1)

dump the database

set the default charsets to UTF8 in /etc/my.cnf

restart the mysql

create the database again with the right charset and collation

dump the file back into it

Code:
2-

save my file in the UTF8 encoding (with notepad++)

Code:
3-

change the charset/collation on my tables

If anyone has any idea to fix this issue, it would be VERY appreciated.

Thank you very much and have a nice day
--Samus535

03-19-2014, 03:47 AM

[eluser]InsiteFX[/eluser]

Code:
// HTML

&lt;head&gt;

    &lt;meta charset="utf-8" /&gt;

&lt;/head&gt;

// php.ini

default_charset = "utf-8"

// CI Database should be utf8_general_ci or utf8_unicode_ci - database needs to be loaded.

mysql_set_charset('utf8', $this->db->conn_id);

03-19-2014, 08:20 PM

[eluser]samus535[/eluser]
Thank you SOOOO much !!!!

The issue was my php.ini file.

Thanks again :coolsmile:

--Samus535