我如何使用php将泰卢固语字符插入mysql? [英] How do i insert telugu characters into mysql using php?

问题描述

将泰卢固语字符插入类别

inserting telugu characters as category

但是它看起来像这样

推荐答案

我遇到了 UTF-8字符的相同问题，一切都在实时服务器和登台服务器上运行，但有时会中断我的开发机器.这种行为是如此奇怪，有时字符已正确编码，但在随机页面重新加载时，它开始被 Diamond Charters ' เห็นอเวิลด์！. ' 或问号 '????เห็นอเวิลด์！???' 或85％的数据已正确呈现 'เห็นอเวิลด์！? ' ，但其余15％的用户显示不匹配的字符.我一直在寻找解决问题的方法.所以，从我的清单开始

I was facing same issue for UTF-8 characters, Everything was working on live server and staging server, but sometime it's breaking on my dev machine. The behavior was so strange, some times characters was encoded properly but on random page reload it was start breaking with Diamond Charters '���เห็นอเวิลด์!���' or Question mark '??�เห็นอเวิลด์!???' or 85% data was rendering properly 'เห็นอเวิลด์!?��' but rest 15% was showing unmatched characters. I was looking to fix the issue. So, started with my checklist

1-检查是否在HTML中添加了字符标题

---

2-检查数据是否正确保存在MySQL表中

---

3-检查MySQL是否为UTF-8设置了正确的编码设置

---

4-检查Apache是​​否具有处理UTF-8字符集的设置

---

5-检查简单的PHP是否可以回显与输入เห็นอเวิลด์"相同的เห็นอเวิลด์"输出

---

6-检查PHP是否发送正确的标头输出

---

7-检查MySQL查询是否获得相同的数据เห็นอเวิลด์"

---

8-检查เห็นอเวิลด์"是否包含一些html字符，并对其进行正确处理

---

9-检查เห็นอเวิลด์"是否通过任何html编码解码功能

---

10-检查.htaccess是否都设置为处理UTF-8字符集

---

检查以上所有列表，找出出现问题的地方.

Check all the above list to figure out where something..breaking.

尝试一下(我正在使用Codeigniter):

=================================
:: PHP ini Settings::
=================================

default_charset = "utf-8"
mbstring.internal_encoding=utf-8
mbstring.http_output=UTF-8
mbstring.encoding_translation=On
mbstring.func_overload=6 

=================================
:: .htaccess Settings::
=================================

DefaultLanguage en-US
AddDefaultCharset UTF-8

=================================
:: HTML Header Page::
=================================

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

=================================
:: PHP Codeigniter index.php ::
=================================

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

=================================
:: Codeigniter config.php ::
=================================

$config['charset'] = 'UTF-8';

=================================
:: Codeigniter database.php ::
=================================

$db['default']['char_set'] = 'utf8';
$db['default']['dbcollat'] = 'utf8_general_ci';

=================================
:: Codeigniter helper function (optional)
=================================

if(!function_exists('safe_utf_string')){
    function safe_utf_string($utf8string= ''){
        $utf8string = htmlspecialchars($utf8string, ENT_QUOTES, 'UTF-8');
        return mb_convert_encoding($utf8string, 'UTF-8');
    }
}

祝你好运！:)

Good luck!! :)

这篇关于我如何使用php将泰卢固语字符插入mysql?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！