Newsgroups: php.internals Path: news.php.net Xref: news.php.net php.internals:15116 Return-Path: Mailing-List: contact internals-help@lists.php.net; run by ezmlm Delivered-To: mailing list internals@lists.php.net Received: (qmail 15930 invoked by uid 1010); 20 Feb 2005 10:12:12 -0000 Delivered-To: ezmlm-scan-internals@lists.php.net Delivered-To: ezmlm-internals@lists.php.net Received: (qmail 67215 invoked from network); 20 Feb 2005 09:44:53 -0000 Received: from unknown (HELO lists.php.net) (127.0.0.1) by localhost with SMTP; 20 Feb 2005 09:44:53 -0000 X-Host-Fingerprint: 212.112.227.169 ipx11223.ipxserver.de Linux 2.4/2.6 Received: from ([212.112.227.169:58442] helo=ipx11223.ipxserver.de) by pb1.pair.com (ecelerity 1.2 (r4437)) with SMTP id 86/C9-06388-41C58124 for ; Sun, 20 Feb 2005 04:44:52 -0500 Received: from localhost (localhost [127.0.0.1]) by ipx11223.ipxserver.de (Postfix) with ESMTP id 63F0FDF00FF; Sun, 20 Feb 2005 10:45:26 +0100 (CET) Received: from ipx11223.ipxserver.de ([127.0.0.1]) by localhost (ipx11223 [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 04518-05; Sun, 20 Feb 2005 10:45:23 +0100 (CET) Received: from [192.168.0.100] (i528C1A6C.versanet.de [82.140.26.108]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by ipx11223.ipxserver.de (Postfix) with ESMTP id 73BDBDF004A; Sun, 20 Feb 2005 10:45:23 +0100 (CET) Message-ID: <42185C0B.3000308@php.net> Date: Sun, 20 Feb 2005 10:44:43 +0100 User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Timm Friebe Cc: internals@lists.php.net References: <1108836903.316.40.camel@localhost> In-Reply-To: <1108836903.316.40.camel@localhost> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by somedaemon at backendmedia.com Subject: Re: PDO types From: lsmith@php.net (Lukas Smith) Timm Friebe wrote: > while testing PDO I was astonished to see that all values (regardless of > their types in the database) are returned as strings (in all extensions > except for PgSQL). Why is that so? It _is_ quite inconsistent, isn't it? > Wasn't PDO supposed to _unify_ the RDBMS access apis? I dont know the actual implementation but at the last meeting we came to the conclusion that PDO will pass back proper types if the RDBMS does and strings if the RDBMS doesnt. Anything more would require the users from providing this metadata or PDO jumping through alot of hoops to fetch this information from the RDBMS. BTW: ibase will probably (eventually) also fall in the sam categorie because iirc Ard was the one who started the discussion on this at the last meeting. regards, Lukas