I'm trying to insert Arabic language to mssql database. database column is set to nvarchar Data is posted through PHP to a mssql stored procedure.
the problem is : data got inserted as މުއްދަތު Þ‡Þ¨Þްތިއުނާފް ÞŠÞ¯Þ‰Þ¬
could any one please help me to get the correct data to be inserted without converting.
> <?php header('Content-Type: text/html; charset=utf-8'); include_once
> 'connect.php';
>
> sqlsrv_query ($conn,"set character_set_client='utf8'");
> sqlsrv_query ($conn,"set character_set_results='utf8'");
> sqlsrv_query ($conn,"set collation_connection='utf8_general_ci'");
>
>
>
> $tsql = 'Exec SP @NO=?,@Date=?,@IN=?,@creason=?';
> $params = array($empno,$dutydate,$inDT,$outDT,$reason);
>
> $stmt = sqlsrv_query($conn,$tsql,$params) ;
>
> $dataArray = array();
> if ($stmt === false) { echo 'SQL Error'; print_r(sqlsrv_errors()); } else {
>
>
>
> $dataArray['error'] =array();
> while ($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)) {
> array_push($dataArray['error'],$row);
> }
> sqlsrv_free_stmt($stmt);
>
> } echo json_encode($dataArray);
>
> ?>