php mysql insert into utf-8 [closed]

Question

I'm going to insert into some articles in mysql using PHP.

This is phpMyAdmin information:

Server: localhost via TCP/IP
Server version: 5.0.85-community-nt
Protocol version: 10
User: root@localhost
MySQL charset: UTF-8 Unicode (utf8) 

Here is my table information:

Table   Action  Records 1  Type  Collation  Size  Overhead  
article       10 InnoDB utf8_unicode_ci 16.0 KiB - 
1 table(s)  Sum 10 InnoDB utf8_unicode_ci 16.0 KiB 0 B

I add

<?php header('Content-type:text/html; charset=utf-8'); ?> 

in the top of my php code, add mysql_query("set names 'utf-8'"); before mysql_select_db("data",$db1);

but the data in the mysql is still like

più freddi

How do I show the data correctly?

Answer 1

Get rid of the hyphen. It should be:

mysql_query("SET NAMES utf8");

Answer 2

Use following code for inserting

mysql_query("SET character_set_results = 'utf8', character_set_client = 'utf8', character_set_connection = 'utf8', character_set_database = 'utf8', character_set_server = 'utf8'");
mysql_query($qry);

This is worked fine in my case