| Package home | Report new bug | New search | Development Roadmap | Status: Open | Feedback | All | Closed Since Version 1.5.0b4 |
| Bug #20263 | MYsql and Mysqli are eating newlines | ||
|---|---|---|---|
| Submitted: | 2014-05-03 16:49 UTC | ||
| From: | gzuki | Assigned: | |
| Status: | Open | Package: | MDB2_Driver_mysql (version 1.5.0b4) |
| PHP Version: | Irrelevant | OS: | Ubuntu |
| Roadmaps: | (Not assigned) | ||
[2014-05-03 16:49 UTC] gzuki
(Mario Gzuk)
Description:
------------
Hi,
if you have newlines at the end of a text (bigtext field) the driver in this versions doesnt return that. With 1.4.1 all works fine.
Test script:
---------------
$wheresql="WHERE ".$db->quoteIdentifier($idname)."='".$db->escape($id)."'";
$sql="SELECT * FROM ".$db->quoteIdentifier($tablename)." $wheresql";
$res=$db->query($sql);
if (!MDB2::isError($res))
{
$entry=$res->fetchAll();
if (count($entry)>0)
{
$rentry=$entry[0];
}
else
{
//no result
$rentry=array();
}
}
Expected result:
----------------
all between the "###"
###
newlinetest
###
Actual result:
--------------
all between the "###"
###
newlinetest
###