php mysql 插入 utf-8

2022-01-09 00:00:00 utf-8 insert php mysql

我将使用 PHP 在 mysql 中插入一些文章.

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

这是 phpMyAdmin 信息:

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)

这是我的餐桌信息:

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

我加了

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

在我的 php 代码顶部，添加 mysql_query("set names 'utf-8'"); 之前 mysql_select_db("data",$db1);

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

但是mysql里面的数据还是像

but the data in the mysql is still like

più freddi

如何正确显示数据?

推荐答案

去掉连字符.应该是:

mysql_query("SET NAMES utf8");

相关文章