MySQL无法识别韩文字符 [英] MySQL cannot recognize Korean characters

问题描述

我需要将韩文文本插入到通过url get请求来的数据库中.但是，在MySQL中无法识别插入的值.请，需要快速的指导.谢谢.

I need to insert korean text to my database which is coming by url get request. However, inserted values are not recognized in MySQL. Please, need quick instruction. Thanks.

setlocale(LC_CTYPE, 'ko_KR.utf8');
mb_internal_encoding("UTF-8");    
mb_http_output('utf-8');   

$p_text = rawurldecode($_GET["text"]);

推荐答案

在连接mysql之后立即进行此查询

Right after your mysql connection make this query

$mysqli->query("SET NAMES 'UTF8'");

或

mysql_query("SET NAMES 'UTF8'");

还请确保您的字段具有utf8_general_ci排序规则

also make sure that your fields have utf8_general_ci collation

这篇关于MySQL无法识别韩文字符的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！