Newsgroups: php.internals Path: news.php.net Xref: news.php.net php.internals:83999 Return-Path: Mailing-List: contact internals-help@lists.php.net; run by ezmlm Delivered-To: mailing list internals@lists.php.net Received: (qmail 55676 invoked from network); 27 Feb 2015 13:25:22 -0000 Received: from unknown (HELO lists.php.net) (127.0.0.1) by localhost with SMTP; 27 Feb 2015 13:25:22 -0000 Authentication-Results: pb1.pair.com header.from=lester@lsces.co.uk; sender-id=unknown Authentication-Results: pb1.pair.com smtp.mail=lester@lsces.co.uk; spf=permerror; sender-id=unknown Received-SPF: error (pb1.pair.com: domain lsces.co.uk from 217.147.176.214 cause and error) X-PHP-List-Original-Sender: lester@lsces.co.uk X-Host-Fingerprint: 217.147.176.214 mail4-2.serversure.net Linux 2.6 Received: from [217.147.176.214] ([217.147.176.214:53961] helo=mail4.serversure.net) by pb1.pair.com (ecelerity 2.1.1.9-wez r(12769M)) with ESMTP id CF/1F-32582-04070F45 for ; Fri, 27 Feb 2015 08:25:21 -0500 Received: (qmail 27840 invoked by uid 89); 27 Feb 2015 13:25:16 -0000 Received: by simscan 1.3.1 ppid: 27833, pid: 27837, t: 0.0653s scanners: attach: 1.3.1 clamav: 0.96/m:52/d:10677 Received: from unknown (HELO ?10.0.0.8?) (lester@rainbowdigitalmedia.org.uk@86.189.147.37) by mail4.serversure.net with ESMTPA; 27 Feb 2015 13:25:16 -0000 Message-ID: <54F0703C.1050608@lsces.co.uk> Date: Fri, 27 Feb 2015 13:25:16 +0000 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:31.0) Gecko/20100101 Thunderbird/31.4.0 MIME-Version: 1.0 To: internals@lists.php.net References: <3d639901ae85227b219e7ee59b3140fe@mail.gmail.com> <0b3a01d0528e$fdf61160$f9e23420$@php.net> In-Reply-To: <0b3a01d0528e$fdf61160$f9e23420$@php.net> Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit Subject: Re: [PHP-DEV] A different user perspective on scalar type declarations From: lester@lsces.co.uk (Lester Caine) On 27/02/15 13:12, François Laupretre wrote: > If we allow for trailing blanks, we'll allow the same set of chars > that is already allowed for leading blanks. > > I say'blanks' and not 'whitespaces', because here is the list > currently allowed as leading blank (with ascii values) : Space (32) , > tab (9) , linefeed (10), carriage-return (13), vertical tab (11), and > form feed (12). Depending on the way a database is configured, one may be using char fields which are 'blank packed' fixed length, or varchar which would normally only include white space when it is actually added. It's not uncommon though to cast numeric fields to 'char' to create fixed length records and I would not like to say how many legacy systems still use that approach for building tables of data? -- 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 Rainbow Digital Media - http://rainbowdigitalmedia.co.uk