+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived General Discussion (https://forum.codeigniter.com/forumdisplay.php?fid=21)
+--- Thread: Problem with Turkish characters (/showthread.php?tid=31044)
Problem with Turkish characters - El Forum - 06-04-2010
[eluser]bhakti.thakkar[/eluser]
Hi all,
I have a problem with CI. When I try to get Turkish characters from DB strange characters appears. With CI I can’t see them normal. My database saves it correct. BTW database is MSSQL and the collation is Latin1_General_CI_AS
AAş Ticaret ve Yatırım Şaaaaa gets printed as AA?? Ticaret ve Yat?r?m ?aaaaa
Headers:
<meta http-equiv="Content-Type" content="text/html;charset=utf-8" />
In database.php:
$db['default']['char_set'] = "utf8";
$db['default']['dbcollat'] = "utf8_general_ci";
Problem with Turkish characters - El Forum - 06-04-2010
[eluser]flaky[/eluser]
your database collation needs to be utf8
Problem with Turkish characters - El Forum - 06-04-2010
[eluser]flaky[/eluser]
your database collation needs to be utf8.
sorry misread mssql as mysql
try
Turkish_CI_AS
Problem with Turkish characters - El Forum - 06-04-2010
[eluser]bhakti.thakkar[/eluser]
Will i have to do that just at table level or it will be at database level? and what will be the counter effects of the same. As this will be a production change and the DB is really really huge, i am worried
Problem with Turkish characters - El Forum - 06-04-2010
[eluser]flaky[/eluser]
do it at the database level
Problem with Turkish characters - El Forum - 06-04-2010
[eluser]bhakti.thakkar[/eluser]
Also there are other applications connected to that DB. Can there be any other solution? Also the database is saving it correctly. Its PHP / CI issue. So can there be some other alternative?? and