问题描述:

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: [email protected]

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?

网友答案:

Get rid of the hyphen. It should be:

mysql_query("SET NAMES utf8");
网友答案:

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

网友答案:

You have to specify the character encoding on the client as well, use

<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
相关阅读:
Top