Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u15RB-00DqB6-Ju for pgsql-admin@arkaria.postgresql.org; Sat, 05 Apr 2025 15:28:02 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1u15R9-00EcRi-1E for pgsql-admin@arkaria.postgresql.org; Sat, 05 Apr 2025 15:27:59 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u15R8-00EcRY-MD for pgsql-admin@lists.postgresql.org; Sat, 05 Apr 2025 15:27:58 +0000 Received: from mailout.easymail.ca ([64.68.200.34]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1u15R6-00382i-32 for pgsql-admin@lists.postgresql.org; Sat, 05 Apr 2025 15:27:57 +0000 Received: from localhost (localhost [127.0.0.1]) by mailout.easymail.ca (Postfix) with ESMTP id 3CA8D610F7; Sat, 5 Apr 2025 15:27:55 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=elevated-dev.com; s=easymail; t=1743866875; bh=bFnAUy46nj6/Htsmz+SdF8ofhhdq5VAmMx1vgkwkw3s=; h=Subject:From:In-Reply-To:Date:Cc:References:To:From; b=2THYERpvZbiPuA+zIpx40nRl48xQDI0dDqBFFJQhNtAfBiNr8ysqLrp3XApUxyZrZ FPWCIdKr2hFXVP6NwMx++EDMClQ50DovjdarVCidNyMHl8cMRuyy7ikgKupCbXATCV Gslidr8j/gsWSIih06nhGrJHp0Vn48R/R26vEODUJbyWHE1oj9AOP/OV24IlBZjavr GVixjw7fQ7WhjENqbe1FO5aVOynLX4J82vnUrIqcm3gurUuIGa/ZAkEUEbtWX7jio0 E9BNkNuRbo23vwwpe27s9Tjcxraq2Zdmwe+KFy73Z/SC36ARL2RcB1eq60ceJ9s+cR 3dQFXhO0NJXew== X-Virus-Scanned: Debian amavisd-new at emo09-pco.easydns.vpn Received: from mailout.easymail.ca ([127.0.0.1]) by localhost (emo09-pco.easydns.vpn [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id tKiHvTDJy4Wz; Sat, 5 Apr 2025 15:27:54 +0000 (UTC) Received: from smtpclient.apple (unknown [165.140.184.195]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by mailout.easymail.ca (Postfix) with ESMTPSA id A1F88610F0; Sat, 5 Apr 2025 15:27:54 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=elevated-dev.com; s=easymail; t=1743866874; bh=bFnAUy46nj6/Htsmz+SdF8ofhhdq5VAmMx1vgkwkw3s=; h=Subject:From:In-Reply-To:Date:Cc:References:To:From; b=rN1C5wr6itvgpHDi19Oe/xfZ2wobXpSGoV+oCty9kRba9v09rXPFdi34IjAIk0Tlj 8cT5OKvOtIH+g/GVm+8NhPFe9tpybRV+kiTv4AO786ij72a/bcV3Gz6RTnEO79SSDk bmBk3VjcYncj4vFVYAqdGjQHGpf/ENhOpUJC49MX5pmG1XR6rXqTMLZKJ3IUXCAlvd 0W/SFbg3vIng71ZGzRi+6X1DMMPgjv7gdy8DlWicghDnRgHG2iIheYTW/bx5QWnC3j CokQH3zrUfSSc4U9diISFTPFPm1nM23Ydl/ik4dsqa4Qq7xVrQFMjgeklQPAX32L5r XC9Tt6xazKZ/Q== Content-Type: text/plain; charset=utf-8 Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3826.400.131.1.6\)) Subject: Re: Issue with retrieving data when the column has @- in it's value From: Scott Ribe In-Reply-To: Date: Sat, 5 Apr 2025 09:27:43 -0600 Cc: pgsql-admin Content-Transfer-Encoding: quoted-printable Message-Id: References: To: Teju Jakkidi X-Mailer: Apple Mail (2.3826.400.131.1.6) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > On Apr 5, 2025, at 9:18=E2=80=AFAM, Laurenz Albe = wrote: >=20 > Also, compare the collations shown in the \l output for the database. And glibc versions...