Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:99052
Mailing-List: contact internals-help@lists.php.net; run by ezmlm
Received-SPF: pass (pb1.pair.com: domain marcodor.com designates 93.115.138.71 as permitted sender)
To: <internals@lists.php.net>
Date: Mon, 15 May 2017 19:22:04 +0300
Organization: Marcodor
Message-ID: <002801d2cd97$63921700$2ab64500$@marcodor.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0029_01D2CDB0.88DFEB40"
Thread-Index: AdLNlZ/Hv1aL+ZMrTFSOaNUgedkExA==
Content-Language: ro
Subject: PDO Parameter types // PDO::PARAM_AUTO
From: dorin.marcoci@marcodor.com ("Dorin Marcoci")

------=_NextPart_000_0029_01D2CDB0.88DFEB40
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

Hello Everyone!

 

Currently PDOStatement::bindValue is declared as

public bool PDOStatement::bindValue ( mixed $parameter , mixed $value [, int
$data_type = PDO::PARAM_STR ] )

where third parameter is data type, string type as default.

 

It may be useful in terms of providing meta info and handle it accordingly,
like quote, cast or do some additional stuff.

 

But there are DBMSes where this "feature" is more a burden than a helper.

 

It's because after PDO::prepare, driver and server already knows all
statement parameters and expected types.

Yes, it can be "forced", saying to pass for a integer parameter a string
value, server will convert it to required type.

It is convenient in most cases to pass them as strings, for example by
simply assign all params in a cycle before execute.

 

But when implementing FB Boolean data type parameters and doing ->bindValue
('bool_param', false) I get an empty string internally.

Yes, true ZVAL is converted as string as '1', but false as an empty string,
not so consistent here ;)

 

That's why I think, it will be great to have a special type like
PDO::PARAM_AUTO and a config flag to set it as default instead of PARAM_STR.


 

Any thoughts?

 

-

  Dorin


------=_NextPart_000_0029_01D2CDB0.88DFEB40--