PHP 4.0 Bug #10030: field returned from odbc read with only 3989 chars, not all
| From: | gordonl at tts-sf dot com | Date: | Tue, 27 Mar 2001 19:27:17 +0000 |
| Subject: | PHP 4.0 Bug #10030: field returned from odbc read with only 3989 chars, not all | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-50097@lists.php.net to get a copy of this message | ||
From: gordonl@tts-sf.com
Operating system: mandrake linux 2.2
PHP version: 4.0.3pl1
PHP Bug Type: ODBC related
Bug description: field returned from odbc read with only 3989 chars, not all
We have an informix database, with the informix odbc driver(7.x) compiled with apache.3.1.14ssl, php
4.03.pl1.
Our configure commands included the informix via " --with-custom-odbc=/opt/informix ".
We do not use any of the informix ifx functions, but the php odbc functions. The code in question is
as follows:
--------------------------------
$crs = odbc_pconnect($host,$dblogonname,$dbpassword);
$i = odbc_exec($crs,"set role " . $dbrole);
$sqltxt = "select mt_id,mt_name,mt_faxattachments,mt_emlattachments, mt_text,mt_bcc,
mt_faxcoverpage,mt_subject from mail_templates where mt_id = " . $id;
//echo("sql " . $sqlTxt . "sql");
$rsm = odbc_exec($crs,$sqltxt);
$rsma = odbc_fetch_row($rsm);
$mtid = odbc_result($rsm,1); //int
$mtname = odbc_result($rsm,2); // string 20
$mtfaxattachments = odbc_result($rsm,3); // string 255
$mtemlattachments = odbc_result($rsm,4); // string 255
$mttext = odbc_result($rsm,5); // text (blob)
$mtbcc = odbc_result($rsm,6); // string 255
$mtfaxcoverpage = odbc_result($rsm,7); // char 8
$mtsubject = odbc_result($rsm,8); // char 80
//echo("sql " . $mttext . "sql");
---------------------------------------------------
Through a data base editor, the mt_text field actually had approximately 4100 characters, but the
echo command just above only displayed the first 3989 chars. Our c++ programmer can access the full
field in his programs.
--
Edit Bug report at: http://bugs.php.net/?id=10030&edit=1