Topic: MSSQL, executing Stored Procedure not returning correct characters using JSON

[core000]

I'm using PHP to access SQL Server Stored Procedure.   However, the

characters are not returning correctly using JSON.

Database value
--------------

_ResourceGuid               
'341EEB0B-9D71-4805-8380-000C53BAE950'

ResourceGuid
'341EEB0B-9D71-4805-8380-000C53BAE950'

status   
'Active'


PHP Returned JSON array
-----------------------

[{"_ResourceGuid":"\u000b","Resourceguid":"\u000b","status":"Active",".....


Code below:
-------------------

<?php 

$myServer = "server"; 
$myUser = "user";
$myPass = "passw";
$myDB = "mydatabase";

$conn = mssql_connect($myServer, $myUser, $myPass, $myDB); 



$sql ="EXEC spassetreport"; 

/*$result = mssql_query("SET ANSI_NULLS ON") or
die(mssql_get_last_message());*/
$result = mssql_query("SET ANSI_WARNINGS ON") or
die(mssql_get_last_message());

$data = mssql_query( $sql, $conn);    


$result = array();    

do { 
    while ($row = mssql_fetch_object($data)){ 
        $result[] = $row;    
    } 
}while ( mssql_next_result($data) ); 

echo json_encode($result);

mssql_close($conn); 
?>