core000 Posted February 4, 2010 Share Posted February 4, 2010 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); ?> Link to comment https://forums.phpfreaks.com/topic/190958-mssql-executing-stored-procedure-not-returning-correct-characters-using-json/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.