Newsgroups: php.internals Path: news.php.net Xref: news.php.net php.internals:58997 Return-Path: Mailing-List: contact internals-help@lists.php.net; run by ezmlm Delivered-To: mailing list internals@lists.php.net Received: (qmail 91393 invoked from network); 18 Mar 2012 08:58:16 -0000 Received: from unknown (HELO lists.php.net) (127.0.0.1) by localhost with SMTP; 18 Mar 2012 08:58:16 -0000 Authentication-Results: pb1.pair.com smtp.mail=lester@lsces.co.uk; spf=permerror; sender-id=unknown Authentication-Results: pb1.pair.com header.from=lester@lsces.co.uk; sender-id=unknown Received-SPF: error (pb1.pair.com: domain lsces.co.uk from 213.123.26.188 cause and error) X-PHP-List-Original-Sender: lester@lsces.co.uk X-Host-Fingerprint: 213.123.26.188 c2beaomr10.btconnect.com Received: from [213.123.26.188] ([213.123.26.188:50839] helo=mail.btconnect.com) by pb1.pair.com (ecelerity 2.1.1.9-wez r(12769M)) with ESMTP id 1A/F0-18036-1A3A56F4 for ; Sun, 18 Mar 2012 03:58:14 -0500 Received: from host81-138-11-136.in-addr.btopenworld.com (EHLO _10.0.0.5_) ([81.138.11.136]) by c2beaomr10.btconnect.com with ESMTP id GQZ18645; Sun, 18 Mar 2012 08:58:06 +0000 (GMT) Message-ID: <4F65A39D.1010103@lsces.co.uk> Date: Sun, 18 Mar 2012 08:58:05 +0000 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:10.0.2) Gecko/20120215 Firefox/10.0.2 SeaMonkey/2.7.2 MIME-Version: 1.0 To: PHP Internals List Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Mirapoint-IP-Reputation: reputation=Good-1, source=Queried, refid=tid=0001.0A0B0301.4F65A39E.000A, actions=tag X-Junkmail-Premium-Raw: score=7/50, refid=2.7.2:2012.3.18.83623:17:7.944, ip=81.138.11.136, rules=__MOZILLA_MSGID, __HAS_MSGID, __SANE_MSGID, __USER_AGENT, __MIME_VERSION, __TO_MALFORMED_2, __SUBJ_ALPHA_END, __CT, __CT_TEXT_PLAIN, __CTE, URI_ENDS_IN_PHP, __ANY_URI, __URI_NO_MAILTO, __CP_URI_IN_BODY, BODY_SIZE_1300_1399, BODYTEXTP_SIZE_3000_LESS, __MIME_TEXT_ONLY, RDNS_GENERIC_POOLED, HTML_00_01, HTML_00_10, BODY_SIZE_5000_LESS, RDNS_SUSP_GENERIC, RDNS_SUSP, BODY_SIZE_2000_LESS, BODY_SIZE_7000_LESS X-Junkmail-Status: score=10/50, host=c2beaomr10.btconnect.com X-Junkmail-Signature-Raw: score=unknown, refid=str=0001.0A0B0207.4F65A39E.00CD:SCFSTAT14830815,ss=1,re=-4.000,fgs=0, ip=0.0.0.0, so=2011-07-25 19:15:43, dmn=2011-05-27 18:58:46, mode=multiengine X-Junkmail-IWF: false Subject: Data type coercion From: lester@lsces.co.uk (Lester Caine) I just though it was worth throwing in this link to the 'debate' on data type hints and casting ... http://dyemanov.blogspot.co.uk/2011/07/data-type-coercion-vs-comparison-rules.html While it goes back a little time wise, it flags the SQL standard which while that is not available to simply view on line ( standards should NOT be a commodity! ) a search for "Result of data type combinations" brings up a few other views on the 'problem'. This is another of those areas where cross database working can produce some unexpected results, and while using databases with PHP is probably not the 'norm', it does provide another target with which consistent type management can be compared. But having said that, MySQL probably fails to follow the standard anyway? In my own case, data from the database normally ends up being returned as strings but with validity checks having been carried out in the database engine, so further 'hinting' within PHP would tend to be a little redundant. -- Lester Caine - G8HFL ----------------------------- Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Engineers Digital Workshop - http://medw.co.uk// Firebird - http://www.firebirdsql.org/index.php