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);
?>


Thanks