Login

11-13-2009, 05:23 PM

[eluser]terbor[/eluser]
I am having a hard time finding this solution. MySQL stores user submitted articles and when I display the article certain characters are thrown into the <?> when I view it in my browser. I dont know if there is a CI setting somewhere where I can add these characters to .... I am having a hard time finding similar issues regarding character encoding with PHP & MySQL. The article is stored as a BLOB (not sure if that matters)

Thanks

11-14-2009, 08:26 AM

[eluser]überfuzz[/eluser]
What charset are you using? My guess is that you should use utf 8, to get all specials.

First step of solving this could be, look through you system and see what you're using.

11-14-2009, 11:59 AM

[eluser]terbor[/eluser]
Thank you for the reply,

In the config.php

Code:
$config['charset'] = "UTF-8";

In the database.php (in config)

Code:
$db['default']['char_set'] = "utf8";

$db['default']['dbcollat'] = "utf8_general_ci";

The issue is that the quotes " and ' are looking like the <?> image when printed on the screen. At least those are the only ones I see right now. I am working local with firefox and in the head I have

Code:
&lt;meta http-equiv="content-type" content="text/html; charset=utf-8" /&gt;

I am not really sure what else could be effecting this...

12-06-2009, 08:29 AM

[eluser]Adrien.[/eluser]
Hi everyone,

I'm having the same kind of trouble, every special character such as french accents is replaced by a <?> character. I'm not retrieving any data from the database, the content of my page is hard coded.

In config.php I have :

Code:
$config['charset'] = "UTF-8";

And in the <head> part of my page I have :

Code:
&lt;meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /&gt;

Thanks in advance !

12-06-2009, 01:31 PM

[eluser]Adrien.[/eluser]
Hi again,

I've just figured out how to fix the problem. I replaced all the :

Code:
&lt;?php $this->load->view('sample/footer_view') ?&gt;

in my view by :

Code:
&lt;?php echo utf8_encode($this->load->view('sample/footer_view','',TRUE)); ?&gt;

But it's quite ugly... Isn't there a sexier way to do this ?

Thanks in advance.

01-05-2010, 02:47 PM

[eluser]RayDube[/eluser]
Hi There,

You may have found a solution since you posted this a month ago, but I also found one after reading this thread and thought I should place it here, for the next guy like me who happens along here. Smile

Code:
&lt;? header('Content-Type: text/html; Charset=UTF-8');  ?&gt;

If you place that at the top of your view, you should be Okey-dokey!

Ray