Login

01-21-2009, 08:46 AM

[eluser]ufucuk[/eluser]
Hi all,
I have a problem with CI. When I need to get Turkish characters from DB strange characters appears.
I can get the same DB from a seperate page normal, however, with CI I can't see them normal.
Headers

Code:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

&lt;html &gt;

&lt;head&gt;

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

&lt;title&gt;&lt;?php echo $title; ?&gt;&lt;/title&gt;

When use charset=utf-8 in a seperate page everything is normal and I see everything clear. What must I do? Any suggestion?
By the way php files are UTF-8 Without BOM.
Thanks.

01-21-2009, 09:03 AM

[eluser]ufucuk[/eluser]
database config file must be

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

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

only if your MYSQL's default parameters are latin1 and latin1_swedish_ci, otherwise, replace them with your own parameters.

01-21-2009, 09:33 AM

[eluser]akifemre[/eluser]
I think you have wrong at your database charset. it should be created as utf8_general_ci collation.

01-21-2009, 09:53 AM

[eluser]ufucuk[/eluser]
I tried that one too. It doesn't matter latin_swedish or utf-8 for Turkish.

01-22-2009, 02:54 AM

[eluser]helmutbjorg[/eluser]
If this is SOLVED... would you mind telling us how?