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

Which is the best character encoding for Japanese language for DB, php, and html display?(哪种是用于 DB、php 和 html 显示的日语的最佳字符编码?)
本文介绍了哪种是用于 DB、php 和 html 显示的日语的最佳字符编码?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我只想了解日语的语言翻译,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

这篇关于哪种是用于 DB、php 和 html 显示的日语的最佳字符编码?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持编程学习网!

本站部分内容来源互联网,如果有图片或者内容侵犯您的权益请联系我们删除!

相关文档推荐

Convert JSON integers and floats to strings(将JSON整数和浮点数转换为字符串)
in php how do I use preg replace to turn a url into a tinyurl(在php中,如何使用preg替换将URL转换为TinyURL)
all day appointment for ics calendar file wont work(ICS日历文件的全天约会不起作用)
trim function is giving unexpected values php(Trim函数提供了意外的值php)
Basic PDO connection to MySQL(到MySQL的基本PDO连接)
PHP number_format returns 1.00(Php number_Format返回1.00)