encoding problem with MSSQL and php

[farukcse]

Dear sir,
i am tring to use mssql with php for my web application.
But i am facing problme with arabic chararcters.
it appears like as ��������� ���.
can anyone tell me how to fix this error?


Regards,
Faruk Chowdhury.

//Query to connect MSSQL

$myServer = 'localhost';
$myUser = 'sa';
$myPass='';
$myDB='pos';


$dbhandle = mssql_connect($myServer,$myUser,$myPass) or die('Error connecting to mssql');


$selected = mssql_select_db($myDB,$dbhandle)or die('Error connecting to mssql');

// Query to retrive informations..

$result1 = mssql_query("select  first_name , family_name ,father_name ,grand_father_name  ,city ,zip_code ,p_o_box ,mobile_no  from client_info where id_no = '$id_no' ");

[ck9663]

I have not tried doing that before. Maybe this would help...

Good Luck!!!

~~ CK