{var%20f='http://v.t.sina.com.cn/share/share.php?appkey=1515056452',u=z||d.location,p=['&url=',e(u),'&title=',e(t||d.title),'&source=',e(r),'&sourceUrl=',e(l),'&content=',c||'gb2312','&pic=',e(p||'')].join('');function%20a(){if(!window.open([f,p].join(''),'mb',['toolbar=0,status=0,resizable=1,width=440,height=430,left=',(s.width-440)/2,',top=',(s.height-430)/2].join('')))u.href=[f,p].join('');};if(/Firefox/.test(navigator.userAgent))setTimeout(a,0);else%20a();})(screen,document,encodeURIComponent,'','','https://www.manongdao.com/data/attach/logo/logo.png', '推荐 仙女界的扛把子 的问题《inserting ô into mysql database is part of Rhône r》','https://www.manongdao.com/q-882178.html','页面编码gb2312|utf-8默认gb2312'));){kind=link}
When I insert the string 'Rhône' into my database, all that remains is 'Rh' How is that possible? Is use Mysql with utf8_general_ci encoding.
<?php
header( 'Content-Type: text/html; charset=utf-8' );
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en-gb" lang="en-gb">
<head>
<meta http-equiv="Content-Type" content="text/html;charset=utf-8" />
<title>Decode</title>
<head></head>
<body>
<?php
include_once ($_SERVER['DOCUMENT_ROOT'] . '/v3/functions/connect.php');
$res_id = $_POST['res_id'];
$yr_id = $_POST['yr_id'];
$yr_id=html_entity_decode($yr_id, ENT_COMPAT, "UTF-8");
if(isset($yr_id) && $yr_id<>'') {
$search = array('%C3%B4');
$replace = array('ô');
$yr_id=str_replace($search, $replace, $yr_id);
mysql_query("SET NAMES utf8");
$uQuery2="UPDATE sv_snowrepublic set yr_id='$yr_id' where res_id=$res_id limit 1";
$uResult2 = mysql_query($uQuery2);
echo 'updated';
}
$uQuery1="SELECT * FROM sv_snowrepublic where res_id=$res_id limit 1";
$uResult1 = mysql_query($uQuery1);
$row1 = mysql_fetch_assoc($uResult1);
if (mysql_num_rows($uResult1) >= 1 && isset($res_id) && $res_id>2)
{
echo "<form method='POST' action='index.php'>";
echo "<input type='hidden' size='4' value='" . $row1['res_id'] . "' name='res_id' /><br />";
$yr2_id=$row1['yr_id'];
// $yr2_id=html_entity_encode($yr2_id, ENT_COMPAT, "UTF-8");
echo mb_detect_encoding($yr2_id);
echo "<input type='text' size='200' value='" . $yr2_id . "' name='yr_id' /><br />";
echo "<br /><label for='submit'></label><input type='submit' name='submit' value=' Send '></form>";
}
?>
</body>
</html>
You have got a problem to transfering the string
Rhôneinto your MySQL database. This can have multiple reasons, most certainly one of the components involved (most certainly MySQL as server or client) runs over a string with an encoding specified which does not match at the character position you commonly refer to asô. As it's the first position the encoding looks invalid, it will get cut off.You must ensure, under all circumstance and without making any error - not even the slightest one in configuration - that the encoding of the data you handle is always clear to you, correctly set-up and properly handled.
That's both for the input into your database as well as for getting the data from your database.
The thing that comes to mind is:
Further on:
SET NAMESinstead of setting up the connection encoding settings properly. Seemysql_set_charsetDocs.Check that, but it's only a guess, there can be many reasons why this happens.
you should set connection encoding to
UTF-8too. Tryafter connection, before first query
If you are using mysql_* functions, you need to make sure you escape the string with mysql_real_escape_string(), however it is recommended to use prepared statements using PDO or mysqli.