Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bQbAl-0001Oi-MI for pgadmin-hackers@arkaria.postgresql.org; Fri, 22 Jul 2016 14:11:27 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1bQbAl-0007zu-3L for pgadmin-hackers@arkaria.postgresql.org; Fri, 22 Jul 2016 14:11:27 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1bQbAk-0007zo-Pt for pgadmin-hackers@postgresql.org; Fri, 22 Jul 2016 14:11:26 +0000 Received: from mail-qk0-x230.google.com ([2607:f8b0:400d:c09::230]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1bQbAh-0004Ar-C9 for pgadmin-hackers@postgresql.org; Fri, 22 Jul 2016 14:11:26 +0000 Received: by mail-qk0-x230.google.com with SMTP id p74so102269789qka.0 for ; Fri, 22 Jul 2016 07:11:22 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb-com.20150623.gappssmtp.com; s=20150623; h=mime-version:from:date:message-id:subject:to; bh=yfq6/ifSlK693Bguta3UH5dyFFNNgAc5yX1VND85EkM=; b=rXoxqLL3AXuk1EfFA0Rs3lOi2EDRnH59oPJOdxFadQDmEAZW4Cow84aVYzZ9PyCE54 A8rjVAas0i4N5/gkySmK0THINNhsuTFDJQEe7ybWJCB5LSyfN6Ymfacoqmo8O1OBzjWG hd6bCK1Z6MIXug6s2bQWFZLNhnFuYgHpxkDuauFGGtjDJ6fVuG8a3Jk5VWrEipWNb+r+ GOkO5aN6b7GoO8wU2Eqd3U8WIReQUOtwcdZtovNVZP2A9IhTJ/oIVH2TfFMhNfP3p1pe OPtzrYmbJu1ojSY7fC3I1+u0JcM0ZEo/UBWmpJ4Thv42q7B4blX/wMD5+xGhOS3EWHxz 0IPA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=yfq6/ifSlK693Bguta3UH5dyFFNNgAc5yX1VND85EkM=; b=KefAE5sFw9ih61GioeJ8oZgrzS4A3EoH24ZIc2b3tCTQwpFbEuo6TwjTIYa7e6fvPf vJp7Dl4o1xSTdkKcrf8mkIamgTXCVmt7FabV67t8WhNBBbB8NYmUFyeVv6y1Hv3V1Jex FhsMcNSPOn53IrqjmDMj07AyAXvJwWe8qCCJlIFHMWQXQZJiz5/0bQQmRd5CxPtNRp81 UYMiQu7xZ85AQ1EY0j39Pf0jKDS+5qRM4jjziEcLC7+Q51xkxzIxB1k3NAfSbBNoDH2M xljeHGu1Vi02l6yEbbRdfCqkHkbZsnwZl+tUOLFf94yqkg8EKPDwUl2H/g6Ozmw+InLG SMUg== X-Gm-Message-State: AEkoouvDSDw8vJy3nXja5L6PZCodmBYOStcJDbJ0F9MmYeTNYHoIIPPsk1L6FgBtSEd0T/cVTaQPtgNgww6q3lMn X-Received: by 10.233.232.23 with SMTP id a23mr4876857qkg.25.1469196681172; Fri, 22 Jul 2016 07:11:21 -0700 (PDT) MIME-Version: 1.0 Received: by 10.55.8.3 with HTTP; Fri, 22 Jul 2016 07:11:01 -0700 (PDT) From: Murtuza Zabuawala Date: Fri, 22 Jul 2016 19:41:01 +0530 Message-ID: Subject: PATCH: Encoding issue with qtLiteral function (pgAdmin4) To: pgadmin-hackers Content-Type: multipart/mixed; boundary=94eb2c03445249ccc105383a02f8 X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgadmin-hackers Precedence: bulk Sender: pgadmin-hackers-owner@postgresql.org --94eb2c03445249ccc105383a02f8 Content-Type: multipart/alternative; boundary=94eb2c03445249ccbe05383a02f6 --94eb2c03445249ccbe05383a02f6 Content-Type: text/plain; charset=UTF-8 Hi, PFA patch to fix the issue when we use qtLiteral function and user enters special characters(like emojis) which it fails to handle. RM#1307 -- Regards, Murtuza Zabuawala EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company --94eb2c03445249ccbe05383a02f6 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi,

PFA patch to fix the issue when we = use qtLiteral function and user enters special characters(like emojis) whic= h it fails to handle.
RM#1307


--
Regards,
Murtuza Zabuawala
<= span style=3D"color:rgb(136,136,136)">EnterpriseDB:=C2=A0http://www.enterprisedb.com
The Enterprise Postg= reSQL Company
--94eb2c03445249ccbe05383a02f6-- --94eb2c03445249ccc105383a02f8 Content-Type: application/octet-stream; name="RM_1307.patch" Content-Disposition: attachment; filename="RM_1307.patch" Content-Transfer-Encoding: base64 X-Attachment-Id: f_iqxtm8720 ZGlmZiAtLWdpdCBhL3JlcXVpcmVtZW50c19weTIudHh0IGIvcmVxdWlyZW1l bnRzX3B5Mi50eHQKaW5kZXggYjIwNTMyMy4uODNhYzhkMyAxMDA2NDQKLS0t IGEvcmVxdWlyZW1lbnRzX3B5Mi50eHQKKysrIGIvcmVxdWlyZW1lbnRzX3B5 Mi50eHQKQEAgLTIxLDcgKzIxLDcgQEAgbGluZWNhY2hlMj09MS4wLjAKIE1h cmt1cFNhZmU9PTAuMjMKIHBhc3NsaWI9PTEuNi4yCiBwYnI9PTEuOS4xCi1w c3ljb3BnMj09Mi41LjIKK3BzeWNvcGcyPT0yLjYuMgogcHljcnlwdG89PTIu Ni4xCiBweXJzaXN0ZW50PT0wLjExLjEzCiBweXRob24tZGF0ZXV0aWw9PTIu NS4wCmRpZmYgLS1naXQgYS9yZXF1aXJlbWVudHNfcHkzLnR4dCBiL3JlcXVp cmVtZW50c19weTMudHh0CmluZGV4IDQ2M2Y3OWUuLmFkNmZhMDIgMTAwNjQ0 Ci0tLSBhL3JlcXVpcmVtZW50c19weTMudHh0CisrKyBiL3JlcXVpcmVtZW50 c19weTMudHh0CkBAIC0yMCw3ICsyMCw3IEBAIGxpbmVjYWNoZTI9PTEuMC4w CiBNYXJrdXBTYWZlPT0wLjIzCiBwYXNzbGliPT0xLjYuMgogcGJyPT0xLjku MQotcHN5Y29wZzI9PTIuNS4yCitwc3ljb3BnMj09Mi42LjIKIHB5Y3J5cHRv PT0yLjYuMQogcHlyc2lzdGVudD09MC4xMS4xMwogcHl0aG9uLWRhdGV1dGls PT0yLjUuMApkaWZmIC0tZ2l0IGEvd2ViL3BnYWRtaW4vdXRpbHMvZHJpdmVy L3BzeWNvcGcyL19faW5pdF9fLnB5IGIvd2ViL3BnYWRtaW4vdXRpbHMvZHJp dmVyL3BzeWNvcGcyL19faW5pdF9fLnB5CmluZGV4IDdiOTAxZDQuLjljNzY5 NTkgMTAwNjQ0Ci0tLSBhL3dlYi9wZ2FkbWluL3V0aWxzL2RyaXZlci9wc3lj b3BnMi9fX2luaXRfXy5weQorKysgYi93ZWIvcGdhZG1pbi91dGlscy9kcml2 ZXIvcHN5Y29wZzIvX19pbml0X18ucHkKQEAgLTE1NjQsOSArMTU2NCwxMyBA QCBjbGFzcyBEcml2ZXIoQmFzZURyaXZlcik6CiAKICAgICBAc3RhdGljbWV0 aG9kCiAgICAgZGVmIHF0TGl0ZXJhbCh2YWx1ZSk6Ci0KLSAgICAgICAgcmVz ID0gYWRhcHQodmFsdWUpLmdldHF1b3RlZCgpCi0KKyAgICAgICAgdHJ5Ogor ICAgICAgICAgICAgcmVzID0gYWRhcHQodmFsdWUpLmdldHF1b3RlZCgpCisg ICAgICAgIGV4Y2VwdCBVbmljb2RlRW5jb2RlRXJyb3I6CisgICAgICAgICAg ICAjIFdlIHdpbGwgaGFuZGxlIHNwZWNpYWwgY2hhcmN0ZXJzIHdpdGggdXRm OCBlbmNvZGluZworICAgICAgICAgICAgYWRhcHRlZCA9IGFkYXB0KHZhbHVl KQorICAgICAgICAgICAgYWRhcHRlZC5lbmNvZGluZyA9ICd1dGY4JworICAg ICAgICAgICAgcmVzID0gYWRhcHRlZC5nZXRxdW90ZWQoKQogICAgICAgICAj IFJldHVybnMgaW4gYnl0ZXMsIHdlIG5lZWQgdG8gY29udmVydCBpdCBpbiBz dHJpbmcKICAgICAgICAgaWYgaXNpbnN0YW5jZShyZXMsIGJ5dGVzKToKICAg ICAgICAgICAgIHJldHVybiByZXMuZGVjb2RlKCkK --94eb2c03445249ccc105383a02f8 Content-Type: text/plain Content-Disposition: inline Content-Transfer-Encoding: 8bit MIME-Version: 1.0 -- Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-hackers --94eb2c03445249ccc105383a02f8--