The problem is the MySQL database, here is an example.

Create a new database with phpMyAdmin called test

Set the database collation to utf8_unicode_ci

Click create

Now you would think that that the database wa created with utf8_unicode_ci WRONG!

Now click on the top orerations tab and look at the collation on the bottom
it is set to latin1_swedish_ci

To fix it click the dropdown and change it to utf8_unicode_ci and click go.

Problem solved.

InsiteFX

Buso - 08 May 2010 02:00 PM

AzizLight - 02 March 2010 04:05 PM

Can anyone confirm what I am saying, and help me solve the problem please?

no, sorry.. I always used utf-8 and never had a problem with CI

Hi all,

I am newbie to Codeigniter so I faced same problem with UTF-8 where using Persian string to insert into database. At first I got something wrong output. But after checking my file headers I have missed header issue. e.g.
<meta http-equiv=“Content-Type” content=“text/html; charset=utf-8” />

This line of code solved all utf-8 unicode text.

Thanks,
Nasir Gulzade

I’ve found a solution to a similar problem. I’ve tried setting headers and adding meta, none of it solved the problem.

Change dbcollat to none. This is what works for me.

AzizLight - 02 March 2010 04:05 PM

Can anyone confirm what I am saying, and help me solve the problem please?

Well, I have struggled with the same problem a day or two - and solved it! However, it might be that we had the same symptoms for different problems.

I have tried to follow http://philsturgeon.co.uk/news/2009/08/UTF-8-support-for-CodeIgniter but it didn’t help me.

I traced the problem to the loading of data to a mysql server from a local SQL-source file. The trick, for me, is to explicitly start my local mysql terminal program with the flag —default-character-set=utf8 when loading the data to the web server. Something like this:

More info at:
http://dev.mysql.com/doc/refman/5.0/en/batch-commands.html

n.b. Code Igniter apparently handles UTF8 fine   ... for me and my Swedish “dots”

I am also fetching the same problem. I tried everything that you all told here but no result.

I am fetching the problem when i am atempting preg_replace for this character

It generates some kind of “