Am o baza de date .mdb si am urmatoarea problema. Am niste tabele care contin diacritice: Agenţii spre exemplu. cand fac o selectie imi zice ca nu le gaseste. Aveti cumva idee ce pot face?
Cod: Selectaţi tot
<?php
//------------------------------------------------------------------------------------------------------------
$mdbFilename = 'C:\xampp\htdocs\horia\db\db.mdb';
$user = '';
$password = '';
$connection = odbc_connect("Driver={Microsoft Access Driver (*.mdb)};Dbq=$mdbFilename", $user, $password);
//------------------------------------------------------------------------------------------------------------
$Result = odbc_exec($connection, "SELECT * FROM Agenţii") or die(odbc_error());
while($row = odbc_fetch_array($Result))
{
print_r($row);
}
//------------------------------------------------------------------------------------------------------------
?>
Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'Agenţii'. Make sure it exists and that its name is spelled correctly., SQL state S0002 in SQLExecDirect in C:\xampp\htdocs\horia\example.php on line 15
Daca redenumesc tabela in Agentii merge, dar nu doresc acest lucru.
Multumesc,
Radu