note 107782 deleted from function.odbc-result by danbrown
| From: | danbrown@php.net | Date: | Thu, 10 May 2012 18:28:21 +0000 |
| Subject: | note 107782 deleted from function.odbc-result by danbrown | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-187760@lists.php.net to get a copy of this message | ||
Note Submitter: BunakovM at meta dot ua
----
About memo MS Access
for get data from memo field of MS Access correctly i add SQL_CUR_USE_ODBC parametr in odbc_connect.
and with this parametr I don't use odbc_longreadlen and odbc_binmode.
<?php
$odbc_conn_id = odbc_connect($odbcConn['dsn'], "", "",
SQL_CUR_USE_ODBC) or die("Couldn't connect to datasource.");
$odbc_query = "SELECT * FROM " . $table_name;
$odbc_res = odbc_exec($odbc_conn_id, $odbc_query);
odbc_longreadlen($odbc_res, 1024*1024);
$temp = odbc_result($odbc_res, 'memo_filed');
echo "memo_filed : " . $temp;
?>