MS Access

[ab4net]

hi all ...
am retriving data from MS Access MDB file ... database ...
the probem is the data stored in arabic language, and when i get the result each arabic word appears like: ???????????????
i changed the page encoding with no good result any help please !!
here is my code:

$conn=odbc_connect('webdata','','');
$sql="SELECT Account_List.Acnt_Code, Account_List.AcntAName, Account_List.AcntEname, Account_List.ATel, Account_List.AFax, Account_List.APoBox, Account_List.AEmail, Account_List.AWeb, Account_List.AArea, Account_List.ACity, Account_List.ACountry, Account_List.SalesMan
FROM Account_List";
$rs=odbc_exec($conn,$sql);
if(!$rs){
echo("error in sql !!");
ecit();
}
while(odbc_fetch_row($rs)){
$acc=odbc_result($rs,"Acnt_Code");
$accname=odbc_result($rs,"AcntAName");
echo $acc."&nbsp;".$accname."<br>";
}

thank you all ....

[bastien]

not sure that access supports unicode needed to store arabic characters

[Roger_Ramjet]

It stores data in unicode by default from Jet 4 onwards (access 2000/2003). Remember, MS sells Office all over the world.

[Charles_Wong]

Hi,

I got a similar problem.

When I tried to write Chinese from PHP to Microsoft Access (through PHP odbc functions), all the words change to ??????????????.. Anybody knows why?

I am using Mysql 5.0 (connections, tables, server are all set to unicode), PHP 4.4.5 and windows 2003 server (English version).