sql server -将来自Latin1_General_CI_AI的PHP MSSQL查询的结果转换为可读字符串


sql server - Converting results from a PHP MSSQL query from Latin1_General_CI_AI to a readable string

我正在从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//改变