From: | Teju Jakkidi <teja(dot)jakkidi05(at)gmail(dot)com> |
---|---|
To: | pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | Issue with retrieving data when the column has @- in it's value |
Date: | 2025-04-05 01:41:48 |
Message-ID: | CAKA2XvYUiaY8f+EzOP4ANLE5g3ni9wAZOFf1r4u_k0YguthZ1Q@mail.gmail.com |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hello Admins,
I have an issue where in the same scenario below works on my POC but
is having an issue in the original db.
Original db - OS : Red Hat (postgres13)
POC db - OS : SUSE (postgres 14)
SELECT char_length("col1"), octet_length("col1"), "col1"
FROM "test_col" WHERE "col1" = 'test_level(at)-1';
The above query returns data in POC, however, on orig db, it does not
return any data.
On orig db, I have to either a dd trim or COLLATE "C" for it to return data.
The collation is same on both the dbs (en_US.UTF-8) and the os locate is
also the same on both.
Column col1 datatype is varchar.
I tried checking if there are any spaces or special characters and did not
see anything in the output.
SELECT char_length("col1"), octet_length("col1"), length("col1"),
encode("col1"::bytea, 'escape')
FROM "test_col" WHERE "col1" = 'test_level(at)-1';
output is the same for both:
char_length | octet_length | length | encode
-------------+--------------+--------+---------------
13 | 13 | 13 | test_level(at)-1
Can anyone guide me on what else can be checked?
Thanks,
Teja.
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2025-04-05 01:46:38 | Re: Issue with retrieving data when the column has @- in it's value |
Previous Message | Mauricio Fernandez | 2025-04-03 13:19:03 | Re: Create foreign table documentation |