blocks|key|3948275|text|很可能你没有设置正确的Mysql客户端编码。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3948276|您必须发出一个SET+NAMES+<encoding>查询，其中<encoding>是您的HTML页面编码。|offset|length|style|CODE|3948277|请注意，没有“外来字符”，只有编码的。|BOLD|3948278|您必须知道字符的编码方式，并在所有三个web应用程序部分中正确设置：|3948279|3948280|数据库。表的编码必须设置为与实际数据编码相匹配。|unordered-list-item|3948281|PHP作为数据库的客户端编码。设置名称提到的above.|3948282|Browser's编码。由上面提到的同事或其他服务器设置设置。|3948283|3948284|entityMap^0|0|7|K|W|A|0|I|1|0|0|Y|0|0|0|O|0|0|S|0|0|V|0|0^^$0|@$1|2|3|4|5|6|7|X|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Y|8|@$D|Z|E|10|F|G]|$D|11|E|12|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|13|8|@$D|14|E|15|F|J]]|9|@]|A|$]]|$1|K|3|L|5|6|7|16|8|@$D|17|E|18|F|J]]|9|@]|A|$]]|$1|M|3|-4|5|6|7|19|8|@]|9|@]|A|$]]|$1|N|3|O|5|P|7|1A|8|@$D|1B|E|1C|F|J]]|9|@]|A|$]]|$1|Q|3|R|5|P|7|1D|8|@$D|1E|E|1F|F|J]]|9|@]|A|$]]|$1|S|3|T|5|P|7|1G|8|@$D|1H|E|1I|F|J]]|9|@]|A|$]]|$1|U|3|-4|5|6|7|1J|8|@]|9|@]|A|$]]|$1|V|3|-4|5|6|7|1K|8|@]|9|@]|A|$]]]|W|$]]

Most likely you didn't set proper Mysql client's encoding. 
You must issue a <code>SET NAMES &lt;encoding&gt;</code> query where <code>&lt;encoding&gt;</code> is your HTML page encoding. 

Please note that there are no "foreign characters" but only encoding. 
You have to know what encoding your characters in and set it up properly in all three web-application parts:

<ul>
<li>Database. Table's encoding must be set to match actual data encoding.</li>
<li>PHP as a database's client encoding. SET NAMES mentioned above.</li>
<li>Browser's encoding. Set by header mentioned fellow SO'ers above or by other server setting.</li>
</ul>

blocks|key|3948235|text|您在数据库中使用什么编码，通过header()或HTML发送到浏览器的编码是什么？确保它们与您输入的数据相匹配。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|3948236|entityMap^0|F|8|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

What encoding are you using in your database, and what encoding are you sending to the browser either via <code>header()</code> or HTML? Make sure they match the data you're putting in.

blocks|key|2588829|text|您应该更改数据库编码，并将PHP标头中的编码指定为UTF-8。MySQL允许您选择默认编码，或基于每个表或每个字段。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2588830|header('Content-Type:+text/html;+charset=UTF-8');|code-block|syntax|javascript|2588831|如果您保持数据库的编码和脚本的编码一致，那么应该不会有任何问题。|2588832|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

You should change your database encoding as well as specify the encoding in the PHP headers to UTF-8. MySQL allows you to choose a default encoding, or on a per-table or per-field basis.

<pre><code>header('Content-Type: text/html; charset=UTF-8');
</code></pre>

If you keep the encoding of your database and that of your scripts consistent you shouldn't have any problems.

blocks|key|684962|text|为了支持这些字符，您必须选择|type|unstyled|depth|inlineStyleRanges|entityRanges|data|684963|684964|包含这些字符的字符集，通常为将字符映射到基础字节流的UTF-16.|unordered-list-item|offset|length|684965|字符编码，通常为|684966|或UTF-8|684967|684968|让我们使用Unicode/UTF-8，因为这是推荐的标准。您必须确保以下几点：|684969|684970|您插入到数据库中的数据是UTF8格式的，或者，如果它不是，您必须转换它(例如使用iconv或mb_convert_encoding)。如果要从HTML插入数据，请确保向elements.|684971|Your数据库添加属性accept-charset="utf-8"必须支持<form>。在MySQL中，参见CREATE+DATABASE语法和supported+character+sets/collations+(read:+encodings)。您应该选择UTF-8/Unicode.|style|CODE|684972|The数据库必须知道PHP驱动程序将以UTF-8格式传递字符串(即，客户端编码必须设置为UTF-8)。在MySQL中，这是通过执行SQL语句来完成的，web服务器必须声明其内容是以SET+NAMES+UTF8.|684973|The+-8编码的。在PHP中，这是通过header('Content-type:+text/html;+charset=utf-8');|684974|完成的。|684975|entityMap|0|LINK|mutability|MUTABLE|url|http://en.wikipedia.org/wiki/UTF-16|1|http://en.wikipedia.org/wiki/UTF-8|2|http://www.php.net/iconv|3|http://www.php.net/mb_convert_encoding|4|http://dev.mysql.com/doc/refman/5.1/en/create-database.html|5|http://dev.mysql.com/doc/refman/5.1/en/charset-charsets.html^0|0|0|Q|6|0|0|0|1|5|1|0|0|0|0|14|5|2|1A|J|3|0|B|M|11|6|1I|F|1I|F|4|20|Z|5|0|2I|E|0|K|1D|0|0^^$0|@$1|2|3|4|5|6|7|1J|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|1K|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|1L|8|@]|9|@$F|1M|G|1N|1|1O]]|A|$]]|$1|H|3|I|5|6|7|1P|8|@]|9|@]|A|$]]|$1|J|3|K|5|E|7|1Q|8|@]|9|@$F|1R|G|1S|1|1T]]|A|$]]|$1|L|3|-4|5|6|7|1U|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|1V|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|1W|8|@]|9|@]|A|$]]|$1|P|3|Q|5|E|7|1X|8|@]|9|@$F|1Y|G|1Z|1|20]|$F|21|G|22|1|23]]|A|$]]|$1|R|3|S|5|E|7|24|8|@$F|25|G|26|T|U]|$F|27|G|28|T|U]|$F|29|G|2A|T|U]]|9|@$F|2B|G|2C|1|2D]|$F|2E|G|2F|1|2G]]|A|$]]|$1|V|3|W|5|E|7|2H|8|@$F|2I|G|2J|T|U]]|9|@]|A|$]]|$1|X|3|Y|5|E|7|2K|8|@$F|2L|G|2M|T|U]]|9|@]|A|$]]|$1|Z|3|10|5|6|7|2N|8|@]|9|@]|A|$]]|$1|11|3|-4|5|6|7|2O|8|@]|9|@]|A|$]]]|12|$13|$5|14|15|16|A|$17|18]]|19|$5|14|15|16|A|$17|1A]]|1B|$5|14|15|16|A|$17|1C]]|1D|$5|14|15|16|A|$17|1E]]|1F|$5|14|15|16|A|$17|1G]]|1H|$5|14|15|16|A|$17|1I]]]]

In order for those characters to be supported, you must choose

<ul>
<li>a character set that contains those characters, typically <a href="http://en.wikipedia.org/wiki/Unicode" rel="nofollow noreferrer">Unicode</a></li>
<li>a character encoding that maps the characters to the underlying bytestream, typically, <a href="http://en.wikipedia.org/wiki/UTF-8" rel="nofollow noreferrer">UTF-8</a> or, less frequently, <a href="http://en.wikipedia.org/wiki/UTF-16" rel="nofollow noreferrer">UTF-16</a>.</li>
</ul>

Let's go with Unicode/UTF-8, because that's the recommended standard. You must ensure these things:

<ul>
<li>The data you insert into the database is in UTF-8, or, if it isn't, you must convert it (e.g. with <a href="http://www.php.net/iconv" rel="nofollow noreferrer">iconv</a> or <a href="http://www.php.net/mb_convert_encoding" rel="nofollow noreferrer">mb_convert_encoding</a>). If you are insert data from HTML forms, make sure you add the attribute <code>accept-charset="utf-8"</code> to your <code>&lt;form&gt;</code> elements.</li>
<li>Your database must support unicode. In MySQL, see the <a href="http://dev.mysql.com/doc/refman/5.1/en/create-database.html" rel="nofollow noreferrer"><code>CREATE DATABASE</code></a> syntax and the <a href="http://dev.mysql.com/doc/refman/5.1/en/charset-charsets.html" rel="nofollow noreferrer">supported character sets/collations</a> (read: encodings). You should pick UTF-8/Unicode.</li>
<li>The database must know the PHP MySQL driver will be passed strings in UTF-8 (i.e., the client encoding must be set to UTF-8). In MySQL, this is done with executing the SQL statement <code>SET NAMES UTF8</code>.</li>
<li>The web server must declare its content is encoded in UTF-8. In PHP, this is done with <code>header('Content-type: text/html; charset=utf-8');</code></li>
</ul>

I am saving some foreign characters quite fine into my mysql database. This is the ones I am using right now for example: いち

When I try to echo out that column from the database, it only shows up as '??'

Why are there question marks showing up when I am trying to echo foreign characters?

Foreign Characters not showing up correctly in php

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我将一些外文字符保存到我的mysql数据库中。这就是我现在正在使用的，例如:いち当我试图从数据库中回显该列时，它只显示为“？？”当我尝试回显外文字符时，为什么会出现问号？

问外文字符在php中不能正确显示
EN

回答 4

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问外文字符在php中不能正确显示EN

回答 4

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问外文字符在php中不能正确显示
EN