我制作了一个应用程序,可以将Android设备上的几个文本输入发送到我的在线数据库。我的应用程序运行良好,但一些用户报告说他们无法使用阿拉伯文本。所以我尝试了一下,当我将阿拉伯文本发送到数据库中时,它会显示为????? ????? ??????
我的PHP脚本:
<?php
$connect = mysql_connect($db_host,$db_uid,$db_pass) or die('could not connect');
mysql_select_db($db_name);
if(mysql_errno($connect))
{
die("Failed to connect to MySQL: " . mysql_error());
}
else
{
echo "success";
mysql_query("SET NAMES 'utf8'"); mysql_query('SET CHARACTER SET utf8');
}
$name = isset($_POST['name']) ? $_POST['name'] : '';
$sex = isset($_POST['sex']) ? $_POST['sex'] : '';
$nationality = isset($_POST['nationality']) ? $_POST['nationality'] : '';
$query = mysql_query( "insert into people (name, sex, nationality) values (N'$name' ,N'$sex', N'$nationality') ", $connect);
print_r($_POST);
if(!$query) echo mysql_error();
mysql_close($connect);
?>
我的Android代码:
DefaultHttpClient httpclient= new DefaultHttpClient();
HttpPost httppost = new HttpPost("http://www.xxxxxxxx.com/thescript.php");
Log.e("done 1st","its here");
try
{
ArrayList<NameValuePair> nameValuePairs = new ArrayList<NameValuePair>();
nameValuePairs.add(new BasicNameValuePair("name", Name.getText().toString()));
nameValuePairs.add(new BasicNameValuePair("sex", Sex.getText().toString()));
nameValuePairs.add(new BasicNameValuePair("nationality", Nationality.getText().toString()));
httppost.setEntity(new UrlEncodedFormEntity(nameValuePairs));
HttpResponse response = httpclient.execute(httppost);
Log.e("done", String.valueOf(response));
}
我尝试了一些方法,但都没有用。
当使用在线PC .php 进行插入操作时,结果是这样的:لببي
---------
我的数据库设置如下:
表排序规则是utf8_general_ci
,类型为MyISAM
它里面的列 (名字、性别、国籍) 如下:
类型是varchar
,排序规则是utf8_general_ci
例如:
输出应该是علي
,但实际上是???