[PHP-ODBC] จะตั้งค่า php อย่างไรให้คอนเน็ค ODBC เป็น UTF 8 ครับ

Quote:

odbc_exec($objConnect, "SET NAMES UTF8");

Quote:

Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC Microsoft Access Driver] Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'., SQL state 37000 in SQLExecDirect in D:\xampplite\htdocs\xxxx.php on line 24

Quote:

<?php
$conn=odbc_connect('ACCESS-SRO','','');
odbc_exec($conn, "SET NAMES UTF8");

if (!$conn)
{exit("Connection Failed: " . $conn);}
$sql="SELECT * FROM 01_creddy_avatar_all";
$rs=odbc_exec($conn,$sql);
if (!$rs)
{exit("Error in SQL");}
echo "<table><tr>";
echo "<th>Companyname</th>";
echo "<th>Contactname</th></tr>";
while (odbc_fetch_row($rs))
{
$compname=odbc_result($rs,"ORIGINAL_CREDDY");
$conname=odbc_result($rs,"NEW_CAMEL");
echo "<tr><td>$compname</td>";
echo "<td>$conname</td></tr>";
}
odbc_close($conn);
echo "</table>";
?>