UTF-8非常奇怪的行为[重复]

This question already has an answer here:

UTF-8 all the way through 14 answers

How can I echo a sql text field into a paragraph?

My code does puts the text in but changes the accents like á to this -> �. I tried adding UTF-8 in the header and removing it.

Removing UTF-A makes the sql content is ok but all the content outside the paragraph messes up.

I checked the DB was using (UTF-8-unicode), The files were saved with UTF-8

Any ideas on what might be wrong?

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

<textarea class="texto" name="textoarticulo"  id="textoarticulo" form="formarticulo" placeholder="Texto del art&iacute;culo...">
 <?
    echo $row['txt4'];

 ?>
</textarea>

</div>

写回答
好问题 0 提建议
关注问题
分享
邀请回答
编辑收藏删除结题
收藏举报

1条回答默认最新

关注

码龄粉丝数原力等级 --

被采纳

被点赞

采纳率
douchenhui5569 2015-11-24 16:28
关注
It's important that your entire code has the same charset to avoid issues where characters displays incorrectly.

Here's a little list of things that has to be set to a specific charset.

Headers

Setting the charset in both HTML and PHP headers to UTF-8

PHP (PHP headers has to be placed before any output: PHP echo, whitespace, HTML!):

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

HTML (HTML-headers are placed within the <head> / </head> tag):

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

Connection

You also need to specify the charset in the connection itself.

PDO (specified in the object itself):

$handler = new PDO('mysql:host=localhost;dbname=database;charset=utf8', 'username', 'password');

MySQLi: (placed directly after creating the connection, $mysqli is the connection object)

$mysqli->set_charset("utf8"); // OOP style mysqli_set_charset($mysqli, "utf8"); // procedural style

MySQL (depricated): (placed directly after creating the connection)

mysql_set_charset("utf8");

Database

Your database and its tables has to be set to UTF-8. Note that charset is not the same as collation.

You can do that by running the queries below once for each database and tables (for example in phpMyAdmin)

ALTER DATABASE databasename CHARACTER SET utf8 COLLATE utf8_unicode_ci; ALTER TABLE tablename CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;

Caution... There are various different situations that need different ALTERs. Details Here . Doing the wrong ALTER is likely to make things worse. -- Rick James

php.ini specification

In your php.ini file, you should specify the default charset for your platform, like this

default_charset = "utf-8";

(This is in essence the same as doing header('Content-Type: text/html; charset=utf-8'); on all pages)

File-encoding

It's also important that the .php file itself is UTF-8 encoded. If you're using Notepad++ to write your code, this can be done in the "Format" drop-down on the taskbar. You should use UTF-8 w/o BOM.

Should you follow all of the pointers above, chances are your problem will be solved. If not, you can take a look at this StackOverflow post: UTF-8 all the way through.
展开全部

本回答被题主选为最佳回答 , 对您是否有帮助呢?

解决无用
评论打赏
分享
举报
编辑

预览
轻敲空格完成输入
显示为

卡片

标题

链接
评论

按下Enter换行，Ctrl+Enter发表内容

编辑

预览

报告相同问题？

关注问题

ctf show-web入门 php特性篇部分题解
2021-02-04 03:13

z.volcano的博客 } } payload： php://filter/read=convert.base64-encode/resource=flag.php #利用LFI来查看源码 /var/www/html/flag.php 绝对路径 ./flag.php 相对路径 php://filter/resource=flag.php php伪协议 web98 include(...
php 领域驱动设计,《领域驱动设计之PHP实现》全书翻译 - 服务
2021-03-17 13:22

weixin_39885683的博客 `CREATED_AT` DATETIME NOT NULL, `UPDATED_AT` DATETIME NOT NULL, PRIMARY KEY (`ID`) ) ENGINE=INNODB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; 由此看来，创建一个订单类的表示相对容易。这种表示...
防止 SQL 注入的 PHP PDO 准备语句教程
2022-08-21 05:13

allway2的博客这是推荐的方法，您显然可以将您的字符集设置为您的应用程序需要的任何内容（尽管 utf8mb4 是相当标准的）。其中任何一种都可以完全接受，尽管 PDO 对大多数用户来说是更好的选择，因为它更简单、更通用，而 MySQLi ...
防止 SQL 注入的 PHP MySQLi 准备语句教程
2022-08-21 05:01

allway2的博客这可能看起来很奇怪，为什么它甚至会保证自己的部分，因为您实际上可以一个接一个地使用准备好的语句。建议使用准备好的语句，因为它们显然更适合防止 SQL 注入并且不太容易出错，因为您不必担心手动格式化——相反...
玄机——第九章-实战篇-运维杰克 wp
2024-07-19 00:31

Peterpan.exe的博客文章目录一、前言二、概览... GET /%24%7B%28%23a%3D%40org.apache.commons.io.IOUtils%40toString%28%40java.lang.Runtime%40getRuntime%28%29.exec%28%22id%22%29.getInputStream%28%29%2C%22utf-8%22%29%29.%28%40...
php7 ext skel_PHP7.3 正式发布
2021-03-22 15:53

VS华的博客 2018-12-06号，php7.3.0正式发布。改动列表及新特性：核心：改进了PHP GC。重新设计了用PHP编写的旧的ext_skel程序，运行：'php ext_skel.php'获取所有选项。这意味着没有依赖关系，因此它可以在Windows上开箱即用。...
Notes Fifteenth Day-渗透攻击-红队-内部信息搜集
2020-10-01 14:07

大余xiyou的博客 ** Notes Fifteenth Day-渗透攻击-红队-打入内网(dayu) ** 作者：大余时间：2020-10-1 请注意：对于所有笔记中复现的这些终端或者...即使是出于好奇而不是恶意，你仍然会因未授权测试行为而陷入很多麻烦。为了个人能更
知乎--LSTM（挺全的）
2017-05-12 03:16

vbskj的博客顺便安利一下theano，theano的自动求导和GPU透明对新手以及学术界研究者来说非常方便，LSTM拓扑结构对于求导来说很复杂，上来就写LSTM反向求导还要GPU编程代码非常费时间的，而且搞学术不是实现一个现有模型完了，得...
全面解析PHP的糟糕设计------功底很深厚啊
2018-11-30 00:49

阿豪Tata的博客因此不得不在这里插入一句, 因为它值得重复: PHP是个业余爱好者的社区. 极少数人设计, 为它工作, 或极少有人知道他们在做什么. (哦, 亲爱的读者, 你当然是个极品例外!) 那些成长了, 想转投其它平台的人, 使整个社区...
易犯错误 | 十个 PHP 开发者最容易犯的错误
2021-10-21 00:01

lxw1844912514的博客点击进入【码农编程进阶笔记】免费获取进阶面试题、文档、视频资源PHP 语言让 WEB 端程序设计变得简单，这也是它能流行起来的原因。但也是因为它的简单，PHP 也慢慢发展成一个相对复杂的语...
mysql进阶-上
2023-03-05 12:32

慢慢来会很快哦的博客举个例子： utf8-polish-ci，表示utf-8的字符集的波兰语的比较规则，ci代表忽略大小写。 utf8-general-ci，就是通用的忽略大小写的utf8字符集比较规则。 utf8mb4_0900_ai_ci中的0900指的是Unicode 9.0的规范，后边...
empt注意事项 php_十个 PHP 开发者最容易犯的错误
2020-12-21 12:20

weixin_39712611的博客 PHP 语言让 WEB 端程序设计变得简单，这也是它能流行起来的原因。但也是因为它的简单，PHP 也慢慢发展成一个相对复杂的语言，层出不穷的框架，各种语言特性和版本差异都时常让搞的我们头大，不得不浪费大量时间去...
没有解决我的问题, 去提问

UTF-8非常奇怪的行为[重复]

1条回答 默认 最新

1条回答默认最新