哪种是用于 DB、php 和 html 显示的日语的最佳字符编码?

2022-01-07 00:00:00 unicode character-encoding php mysql

我只想了解日语的语言翻译,1)哪个是数据库mysql的最佳编码2) 我可以在 HTML 页面中打印哪个/如何打印.?提前致谢.

i just want to know about the language transation for the Japanese, 1) Which is the best encoding for the database mysql 2) Which/how can i print that in HTML page. ? thanks in advance.

推荐答案

UTF-8 毫无疑问.将所有内容都设为 UTF-8.要将 UTF-8 编码的文本放在您的网页上,请在您的 HEAD 标签中使用它:

UTF-8 without a doubt. Make everything UTF-8. To put UTF-8 encoded text on your web page, use this within your HEAD tag:

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

至于 MySQL,将以下内容放入您的 my.cnf (config) 文件中:

As for MySQL, put the following into your my.cnf (config) file:

[mysqld]
collation_server=utf8_unicode_ci
character_set_server=utf8
default-character-set=utf8
default-collation=utf8_general_ci
collation-server=utf8_general_ci

如果您从应用程序执行的查询中从数据库中获取垃圾字符,您可能需要在获取日语文本之前执行这两个查询:

If you're getting garbage characters from the database from queries executed by your application, you might need to execute these two queries before fetching your Japanese text:

SET NAMES utf8
SET CHARACTER SET utf8

相关文章