RE: [PEAR-DEV] MDB postgresql feature request
| From: | Lukas Smith | Date: | Mon, 18 Aug 2003 11:03:30 +0000 |
| Subject: | RE: [PEAR-DEV] MDB postgresql feature request | ||
| References: | 1 | Groups: | php.pear.dev |
| Request: | Send a blank email to pear-dev+get-19963@lists.php.net to get a copy of this message | ||
> From: Jeroen Houben [mailto:jeroen@terena.nl]
> Sent: Monday, August 18, 2003 9:45 AM
> To: Lukas Smith
> >>From: Jeroen Houben [mailto:jeroen@terena.nl]
> >>Sent: Wednesday, August 13, 2003 12:47 PM
> >>Postgresql 7.2 and above do not automatically truncate strings if
they
> >>don't fit the field. Although this complies with the SQL specs, I
> I think MDB somehow has to know the length of the (var)char field and
> the length of the string to be inserted. If the string is longer the
the
> length of the field then MDB can truncate the string so it fits and
then
> insert it. Right now the insert would just fail if the data is to
large
> for the field. A check for PG 7.2 or higher is also needed, because in
<
> PG 7.2 the data will be silently truncated, just like in MySql so in
> that case MDB won't have to do anything.
Ah that is not possible, as all meta infos need to be passed manually to
MDB. With the DataObject port this would however become possible.
Regards,
Lukas