Newsgroups: php.internals Path: news.php.net Xref: news.php.net php.internals:98453 Return-Path: Mailing-List: contact internals-help@lists.php.net; run by ezmlm Delivered-To: mailing list internals@lists.php.net Received: (qmail 5701 invoked from network); 9 Mar 2017 10:03:19 -0000 Received: from unknown (HELO lists.php.net) (127.0.0.1) by localhost with SMTP; 9 Mar 2017 10:03:19 -0000 Authentication-Results: pb1.pair.com header.from=php@beccati.com; sender-id=pass Authentication-Results: pb1.pair.com smtp.mail=php@beccati.com; spf=pass; sender-id=pass Received-SPF: pass (pb1.pair.com: domain beccati.com designates 176.9.123.236 as permitted sender) X-PHP-List-Original-Sender: php@beccati.com X-Host-Fingerprint: 176.9.123.236 box.beccati.com Received: from [176.9.123.236] ([176.9.123.236:52295] helo=box.beccati.com) by pb1.pair.com (ecelerity 2.1.1.9-wez r(12769M)) with ESMTP id 5B/F0-06022-56821C85 for ; Thu, 09 Mar 2017 05:03:18 -0500 Received: from authenticated-user (box.beccati.com [176.9.123.236]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (No client certificate requested) by box.beccati.com (Postfix) with ESMTPSA id 025942002DA; Thu, 9 Mar 2017 11:03:13 +0100 (CET) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=beccati.com; s=mail; t=1489053794; bh=pdrV/0x5f2FBL944Be1wuzrUc1c7h7jb2JRZn6G+xKE=; h=Subject:To:References:From:Date:In-Reply-To:From; b=O3lNKEssCUMcMLf73vY4D0Fx3xsZjRH4TvP5GSTpK0gNfMrymdAI0/OpiJlPPP1ES wJsdi0xHhQJ+WqToW5z8WNn3ePk1O0aDeqLlOIv5a0oXv4X4pqRE4rrwyxzI4Jaci6 fcG4knqqbEfvauPahCDXt8w3hVpvFuQLQdUQpPmaOJz0DgQdrIWBmoH0lk45+Wu136 IgiaGl3+EO9384mgm/htboCPgfpDWPVnnxYaC/+wevpVFhgAvrGHzBuOtqromMJ5kv kuIM2EwEf6tIYJxB21K5s9WzmkllQ2pr9nYsIfrso7AqCqIsmNXRiQLQvlV+gnfWYz B6xKkmytQkEpg== To: Adam Baratz , "internals@lists.php.net" References: Message-ID: Date: Thu, 9 Mar 2017 11:03:13 +0100 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit Subject: Re: [PHP-DEV] Re: [RFC] Extended String Types For PDO From: php@beccati.com (Matteo Beccati) Hi Adam, On 03/03/2017 16:47, Adam Baratz wrote: >> >> Based on some pain points with my team and things I've heard from others, >> I created an RFC to handle "national" character sets for emulated prepared >> statements: >> https://wiki.php.net/rfc/extended-string-types-for-pdo >> > > Thanks all for the feedback so far. I updated the RFC based on what I > heard. Hopefully it clarifies some of the ambiguities mentioned and the > motivation for making this change. It's ultimately about helping PDO > articulate part of the SQL spec. > > Let me know if you have any new questions/concerns. I'm sorry for being late to the party. I too have some doubts, but having clarified the fact that national character types are a SQL-92 standard clears some of them. However, I see no reference about the expected input/output encoding (Unicode data is a bit vague). Is it expected to be UFT-8? Or maybe match the internal encoding of the driver (e.g. UTF-16?)? What happens if I try to quote a latin1 string? Cheers -- Matteo Beccati Development & Consulting - http://www.beccati.com/