Welcome Guest, Not a member yet? Register   Sign In
Problem with Turkish characters
#1

[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";
#2

[eluser]flaky[/eluser]
your database collation needs to be utf8
#3

[eluser]flaky[/eluser]
your database collation needs to be utf8.

sorry misread mssql as mysql

try

Turkish_CI_AS
#4

[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
#5

[eluser]flaky[/eluser]
do it at the database level
#6

[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




Theme © iAndrew 2016 - Forum software by © MyBB