mysql php turkish character issues

Asked Oct 01 '14 at 22:33

Active Oct 01 '14 at 23:07

Viewed 94 times

I have these codes after database connection

mysql_query("SET NAMES 'UTF8'");
mysql_query("SET character_set_connection = 'UTF8'");
mysql_query("SET character_set_client = 'UTF8'");
mysql_query("SET character_set_results = 'UTF8'");

my php form has

<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />

in database I selected utf-8 general-ci and it has ENGINE=InnoDB AUTO_INCREMENT=56 DEFAULT CHARSET=utf8

But I have this result in database: artÄ±kolsunbutÃ¼rkÃ§e

How can I solve this problem for new insert? Thanks

edited Oct 01 '14 at 23:07

asked Oct 01 '14 at 22:33

user_vgizy

You have inserted it before. – sectus Oct 01 '14 at 22:38
Which one I have inserted before? – user_vgizy Oct 01 '14 at 22:40
Had you inserted this value before you started to use SET NAMES? – sectus Oct 01 '14 at 22:45
after write these codes I inserted the turkish line input – user_vgizy Oct 01 '14 at 22:48
`SHOW CREATE TABLE \`yourtable\`;` please. – Sebas Oct 01 '14 at 22:52
I tried it, What should be the result? ENGINE=InnoDB AUTO_INCREMENT=56 DEFAULT CHARSET=utf8 – user_vgizy Oct 01 '14 at 22:58
I did nearly everthing on google! – user_vgizy Oct 01 '14 at 22:59
Yes the result is good but it's better if you can put it in the question like you did for the other queries – Sebas Oct 01 '14 at 23:03
So, it might be a file encoding problem. Check with your file editor that your php and js files are not using DOS/ANSI but UTF8 no bom encoding. – Sebas Oct 01 '14 at 23:03
I use cpanel file manager code editor and I select utf-8 as encoding. There is only one choice as utf-8 – user_vgizy Oct 01 '14 at 23:05
What is the original value? – sectus Oct 01 '14 at 23:25
You use `mysql_connect` to etablish the database connection, right? Not mysqli or PDO, which work with their own connection. – julp Oct 01 '14 at 23:41
Yes, show us connection and insert parts of your code. – sectus Oct 02 '14 at 00:32
possible duplicate of [UTF-8 all the way through](http://stackoverflow.com/questions/279170/utf-8-all-the-way-through) – Mike 'Pomax' Kamermans Oct 02 '14 at 00:35

mysql php turkish character issues

0 Answers0