我正在从apache服务器上查询MS服务器上的CRM2008数据库。
我正试图从我在数据库上创建的视图中获得联系人。
我返回结果很好,但它不是?编码?以我想要的方式
我如何将查询结果转换为可读的东西(由我和我的代码)。
<?php
ini_set('mssql.charset', 'UTF-8');
//connect
$dbconn = mssql_connect($Server, $User, $Pass)
or die("Couldn't connect to SQL Server on $Server");
//select
$selected = mssql_select_db($DB)
or die("Couldn't open database $myDB");
$query = " select contactid from V_UserDetails where emailaddress1 =
'me@you.com' ";
$result = mssql_query($query);
//grab it
while ($row = mssql_fetch_array($result))
{
$user_custid = ($row['contactid']);
}
echo "<b>customer ID:</b> " . $user_custid . "<br />";
输出:
customer ID: &<DŽ���h���"
而不是必需的:
customer ID: 234554345jhg54j34hg54jhg43jh5g34jhg5jhg3jhg34jg
该字段是一个UniqueIdentifier。在select查询中,我将其更改为
$query = " select CONVERT(VARCHAR(36), contactid) from V_UserDetails where emailaddress1 =
'me@you.com' ";
这将像预期的那样从DB中拉出它!排序!
$ data = iconv("utf - 8"、"iso - 8859 - 9",元数据),
iso - 8859 - 9//改变