note 85869 added to function.odbc-connect

From: Date: Mon, 22 Sep 2008 11:21:58 +0000
Subject: note 85869 added to function.odbc-connect
Groups: php.notes 
Request: Send a blank email to php-notes+get-144601@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. $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(); ---- Server IP: 69.147.83.197 Probable Submitter: 88.151.183.67 ---- Manual Page -- http://www.php.net/manual/en/function.odbc-connect.php Edit -- https://master.php.net/note/edit/85869 Del: integrated -- https://master.php.net/note/delete/85869/integrated Del: useless -- https://master.php.net/note/delete/85869/useless Del: bad code -- https://master.php.net/note/delete/85869/bad+code Del: spam -- https://master.php.net/note/delete/85869/spam Del: non-english -- https://master.php.net/note/delete/85869/non-english Del: in docs -- https://master.php.net/note/delete/85869/in+docs Del: other reasons-- https://master.php.net/note/delete/85869 Reject -- https://master.php.net/note/reject/85869 Search -- https://master.php.net/manage/user-notes.php

« previous php.notes (#144601) next »