note 85869 modified in function.odbc-connect by thiago
| From: | thiago@php.net | Date: | Mon, 22 Sep 2008 12:26:38 +0000 |
| Subject: | note 85869 modified in function.odbc-connect by thiago | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-144603@lists.php.net to get a copy of this message | ||
I've been having trouble displaying Russian characters from Access database using ODBC. You
might try this solution, though it is using ADODB.Connection COM connection with added charset
setting.
<?php
$db_connection = new COM("ADODB.Connection", NULL, 1251);
$db_connstr = "DRIVER={Microsoft Access Driver (*.mdb)};
DBQ=C:\DataDir\Employee.mdb;DefaultDir=C:\DataDir";
$db_connection->open($db_connstr);
$rs = $db_connection->execute("SELECT EmpNameLocal, EmpPosLocal FROM tbl_Employee WHERE
ID='$IDNo'");
$rs_fld0 = $rs->Fields(0);
$rs_fld1 = $rs->Fields(1);
while (!$rs->EOF) {
$empNameLoc = $rs_fld0->value;
$empWPPos = $rs_fld1->value;
$rs->MoveNext();
}
$rs->Close();
$db_connection->Close();
?>
--was--
I've been having trouble displaying Russian characters from Access database using ODBC. You
might try this solution, though it is using ADODB.Connection COM connection with added charset
setting.
$db_connection = new COM("ADODB.Connection", NULL, 1251);
$db_connstr = "DRIVER={Microsoft Access Driver (*.mdb)};
DBQ=C:\DataDir\Employee.mdb;DefaultDir=C:\DataDir";
$db_connection->open($db_connstr);
$rs = $db_connection->execute("SELECT EmpNameLocal, EmpPosLocal FROM tbl_Employee WHERE
ID='$IDNo'");
$rs_fld0 = $rs->Fields(0);
$rs_fld1 = $rs->Fields(1);
while (!$rs->EOF) {
$empNameLoc = $rs_fld0->value;
$empWPPos = $rs_fld1->value;
$rs->MoveNext();
}
$rs->Close();
$db_connection->Close();
http://php.net/manual/en/function.odbc-connect.php