SQL Turkish Language displaying issue

Question

I am displaying data with Turkish characters from SQL database of Godaddy but I have issue that it displays Kadıkoy word to Kad?koy. I have set the type to text and collation to utf-8_turkish_ci but it didn't work. Even I have tried ucs2_turkish_ci and latin5_turkish_ci but didn't work.

So please where could be my problem?

See [UTF-8 all the way through](http://stackoverflow.com/a/279279). — eggyal, Jul 18 '13 at 09:46
please check [Solution 1](http://stackoverflow.com/questions/13517189/turkish-characters-are-not-displayed-correctly) and [Solution 2](http://stackoverflow.com/questions/8207043/mysql-encoding-issue-with-turkish-characters) — Digital Alchemist, Jul 18 '13 at 09:52
@FayeqAliKhan I have this already in my code $xml = ""; Do I need to change it? — Luai Kalkatawi, Jul 18 '13 at 10:02

score 0 · Answer 1 · edited Jan 15 '14 at 18:18

0

First of all, make sure the file is actually saved in UTF-8 format. Then check that you have meta tag Content-Type in your html content is "text/html;charset=UTF-8"

In your HTML header:

You can also try calling header('Content-Type: text/html; charset=utf-8'); at the beginning of your PHP script or adding AddDefaultCharset UTF-8 to your .htaccess file.

edited Jan 15 '14 at 18:18

Keith Pinson

7,835
7
61
104

answered Jul 18 '13 at 10:29

Muhammad Asif Mahmood

1,650
1
9
10

SQL Turkish Language displaying issue

1 Answers1