PHP mysql 字符集 utf8 问题

2021-12-28 00:00:00 utf-8 character-encoding php mysql

可能的重复:
UTF-8 全程

我正在其他人已经开发的网站上开发一些新功能.

I'm developing some new features on a website that somebody else already developed.

字符集有问题.

我看到数据库有一些表格是utf8的，有些表格是latin1的

I saw that the database had some tables in utf8 and some in latin1

所以我正在尝试将所有表格转换为 UTF8.

So I'm trying to convert all the tables in UTF8.

我做了一张表(现在这张表的字段也是utf8)，但没有成功.

I did it for one table (also the fields of this table now are utf8), but was not successful.

我使用的是普通的 mysql 连接.我必须把任何配置说它必须用utf8连接到数据库?如果是女巫一?

I'm using the normal mysql connect. I have to put any config to say that it must connect with utf8 to the DB? If yes witch one?

在我的 html 中:

In my html I have:

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

看起来有些字母有效，而有些则显示问号.例如，它无法显示与此不同的 ' '

It looks like some letters works and others display the question mark. For example it not able to display this ’ that is different of this: '

推荐答案

试试这个 

<?php

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

然后在连接中

<?php
 $dbLink = mysql_connect($argHost, $argUsername, $argPassword);
    mysql_query("SET character_set_results=utf8", $dbLink);
    mb_language('uni'); 
    mb_internal_encoding('UTF-8');
    mysql_select_db($argDB, $dbLink);
    mysql_query("set names 'utf8'",$dbLink);
?>

相关文章