ajax, php garbled problem

说好不打脸

I made a small example, only submit the message content, why is there garbled characters? ?
The one who knew how to solve it, searched a lot, and it didn't work.

ajax.php

<! 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">
<head>
<meta http-equiv = "Content-Type" content = "text / html; charset = gb2312" />
<title> Untitled document </ title>
<script language = "javascript">
function InitAjax ()
{
Var ajax = false;
Try {
Ajax = new ActiveXObject ("Msxml2.XMLHTTP");
} Catch (e) {
Try {
Ajax = new ActiveXObject ("Microsoft.XMLHTTP");
} Catch (E) {
Ajax = false;
}
}
If (! Ajax&&typeof XMLHttpRequest! = 'Undefined') {
Ajax = new XMLHttpRequest ();
}
Return ajax;
}

function saveUserInfo ()
{
// Get the return information layer
Var msg = document.getElementById ("msg");
/// Get form object and user information values
Var f = document.form1;
Var name = f.name.value;
Var content = f.content.value;
/// Receive form URL
Var url = "save.php";
// Need the value of POST, connect each variable through&
Var postStr = "name =" + name + "&content =" + content;
// Instantiate Ajax
Var ajax = InitAjax ();

// Open the connection through Post
Ajax.open ("POST", url, true);
/// Define the HTTP header information of the transmitted file
Ajax.setRequestHeader ("Content-Type", "application / x-www-form-urlencoded; charset = gb2312");
// Send POST data

ajax.send (postStr);
// Get execution status
Ajax.onreadystatechange = function () {
// If the execution status is successful, then write the returned information to the specified layer
If (ajax.readyState == 4&&ajax.status == 200) {
Msg.innerHTML = ajax.responseText;
}
}
}

</ script>
</ head>

<body>
<form id = "form1" name = "form1">
<div id = msg> </ div>
  <label>
  <div align = "center">
    <input name = "name" type = "text" id = "name" />
  </ div>
  </ label>
  <p align = "center">
    <textarea name = "content" rows = "8" id = "content">

说好不打脸

Submit in English,
Chinese character error Data too long for column 'name' at row 1
I have added mysql_query ("SET NAMES 'GB2312'");
If the SQL is directly changed to $ sql = "insert into gbook (name, content) values ​​('you you you you you', 'you you you')";
Passing Chinese characters from ajax.php will not work.

why? ? ?

sjfox509

Convert the title and content iconv to try encoding

qijun2005

$ objResponse = new xajaxResponse ('gb2312');

See if this is possible.

seanshun

If your database is encoded in Latin, char (1) represents a single English character.To use this encoding to store Chinese, it takes two bytes.
If the provincial code of your database is GB2312 or utf8, char (1) means one Chinese character and two bytes.
Also, JavaScript itself is encoded in UTF8. It is recommended that your php file is encoded in UTF8.

说好不打脸

What if gb2312 is used? ? The entire website is mostly used gb2312
I also added this sentence ajax.setRequestHeader ("Content-Type", "application / x-www-form-urlencoded; charset = gb2312");

qijun2005

Transcode of obtained data, iconv

说好不打脸

Iconv also tried, the problem remains

landycai

The data you sent in the past is utf-8 encoded ...
$ con = iconv ("utf-8", "gbk", $ con);
$ name = iconv ("utf-8", "gbk", $ name);

Then insert it into the database, then there is no problem. The encoding of the data sent by ajax has nothing to do with the page encoding, because the browser uses unicode to process the data ...

landycai

Iconv also tried, the problem remains
?

impossible...

However, you have a problem with the javascript that sends the data.You should use encodeURIComponent to encode the string before sending it to the server.