Newsgroups: php.internals Path: news.php.net Xref: news.php.net php.internals:120768 Return-Path: Delivered-To: mailing list internals@lists.php.net Received: (qmail 6772 invoked from network); 9 Jul 2023 14:29:32 -0000 Received: from unknown (HELO php-smtp4.php.net) (45.112.84.5) by pb1.pair.com with SMTP; 9 Jul 2023 14:29:32 -0000 Received: from php-smtp4.php.net (localhost [127.0.0.1]) by php-smtp4.php.net (Postfix) with ESMTP id 9799D180382 for ; Sun, 9 Jul 2023 07:29:31 -0700 (PDT) X-Spam-Checker-Version: SpamAssassin 3.4.2 (2018-09-13) on php-smtp4.php.net X-Spam-Level: X-Spam-Status: No, score=-0.5 required=5.0 tests=BAYES_05,DKIM_SIGNED, DKIM_VALID,RCVD_IN_DNSWL_NONE,RCVD_IN_MSPIKE_H2,SPF_HELO_NONE,SPF_NONE, T_SCC_BODY_TEXT_LINE autolearn=no autolearn_force=no version=3.4.2 X-Spam-ASN: AS15169 209.85.128.0/17 X-Spam-Virus: No X-Envelope-From: Received: from mail-ed1-f54.google.com (mail-ed1-f54.google.com [209.85.208.54]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange ECDHE (P-256) server-signature ECDSA (P-256) server-digest SHA256) (No client certificate requested) by php-smtp4.php.net (Postfix) with ESMTPS for ; Sun, 9 Jul 2023 07:29:31 -0700 (PDT) Received: by mail-ed1-f54.google.com with SMTP id 4fb4d7f45d1cf-51e566b1774so459994a12.1 for ; Sun, 09 Jul 2023 07:29:31 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=basereality-com.20221208.gappssmtp.com; s=20221208; t=1688912970; x=1691504970; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=+Ppq6u6ZXtN1GnVB8BWZMzZ5/mXy/TFJRVpqqCZBv3w=; b=uLTaOl0YSirEXCG/XBCH9kH7nb4IQKQd75d3oHuWPAP1/pMVGjPjxR89NldCBHvE0V 4Ty9X1x6RBToPhWfdCG9U3BypjQSfFYwXxoaq6QQ4NbsxoUYxCNrwZGOEZngRT0oZIrH Yxftq/wWzznx/auas9xWV9ctgKOf6wZWynmAmoJcJ1mmZhCf81QnsOrt4shyQ6wvs0AI S2tK4OvFmhVSgWjokLlw9cDODlhInUg0rGEwkZ954/znZKjkl/hb67M65bTOaHEbscFk UXYvniCz8qi7yecuObuFf6ocNCVPKYxKBODImJ9SvMkKBa9qlx5BmEHWxn/rfnpe/61J f38A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1688912970; x=1691504970; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=+Ppq6u6ZXtN1GnVB8BWZMzZ5/mXy/TFJRVpqqCZBv3w=; b=d9k6ICxRF+rVtzvjUcikL7q+aq07SLle9m0TMWg589bBsogmDrUr/SwIFLanPGRCnq 31+Atj9XvCVzsrCRmZBIvq8KIhsq/lLJHwjR7XibtUyTKQJIVqhwfWV3+AI7l7cY0u5y ZONCQBdT91ixyAyaD04ar+GQml9r6U0KIiiLnTPkngQuwmae4HX0p6t0Foypn77MJxim abbS184qddohhhGtYa3iKoIiMvRUofwn9nCgAQ+cvKOC4qm9UbfuiKgrqmRvlP0gfNyT KLB8pB0hJIkCFRnl/LI1L/m95SZvkOb5mF00jUjOYTs8vCjXwvbvIgH58Plemft2vQrR twVQ== X-Gm-Message-State: ABy/qLb+t4/s656Wa/4YTOQZOmrDm9L74Cwlde9YshOSmk0Vj5f79lT/ S5x7VIwgDzBI6eK8O/qF/clyLW7WHB+qaYHc9AeHJg2IIkaSl/x8ph/x7w== X-Google-Smtp-Source: APBJJlHTzNyqEgtAEIfJAX7SysB2FsGth9tqSjgonvwZJ59momoqtqGStdRkhgsGWdrG1MlKqW5QVDBXi7oogIqOAFs= X-Received: by 2002:a50:ed9a:0:b0:51e:c82:6f3b with SMTP id h26-20020a50ed9a000000b0051e0c826f3bmr7959082edr.16.1688912969790; Sun, 09 Jul 2023 07:29:29 -0700 (PDT) MIME-Version: 1.0 References: <44E4F0BD-C56B-4817-B809-AE18622ACE8A@cmpct.info> In-Reply-To: <44E4F0BD-C56B-4817-B809-AE18622ACE8A@cmpct.info> Date: Sun, 9 Jul 2023 15:29:18 +0100 Message-ID: To: Calvin Buckley Cc: internals@lists.php.net Content-Type: text/plain; charset="UTF-8" Subject: Re: [PHP-DEV] Proposal: Binary type for PDO From: Danack@basereality.com (Dan Ackroyd) On Fri, 7 Jul 2023 at 18:39, Calvin Buckley wrote: > > I'd like to hear any oversights, and what could be done to take this > further. I think someone needs to write some code and some tests, and see what happens. It's possible that PARAM_BINARY could be used across all of the PDO drivers that PHP ships with, and for each of them the behaviour with that option is sensible. It's also possible that the behaviour of binary parameters is bespoke to each of the drivers, and that it isn't possible to use PARAM_BINARY in a DB agnostic way. The most realistic way to find out which option is more real, is to write the code + tests....which would need to be done anyway, even assuming the best case scenario. cheers Dan Ack