By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.
CREATE TABLE T (id int, data varchar(255));
INSERT INTO T VALUES
(1, 'C' || U&'\00F4' || E'te d\'Ivoire'),
(2, 'C\u00F4te d\u0027Ivoire'),
(3, 'ArtBindu\u0075\u002e\u002e\u002e'),
(4, '\u0126ello Worl\u014A');
select * from T;
CREATE TABLE
INSERT 0 4
| id | data |
|---|---|
| 1 | Côte d'Ivoire |
| 2 | C\u00F4te d\u0027Ivoire |
| 3 | ArtBindu\u0075\u002e\u002e\u002e |
| 4 | \u0126ello Worl\u014A |
SELECT 4
select id,
data,
REGEXP_REPLACE(data, '\\u[0-9A-F]{4}', '', 1, 0, 'i') as trim_unicode,
unistr(data) as convert_unicode_to_str
from T;
| id | data | trim_unicode | convert_unicode_to_str |
|---|---|---|---|
| 1 | Côte d'Ivoire | Côte d'Ivoire | Côte d'Ivoire |
| 2 | C\u00F4te d\u0027Ivoire | Cte dIvoire | Côte d'Ivoire |
| 3 | ArtBindu\u0075\u002e\u002e\u002e | ArtBindu | ArtBinduu... |
| 4 | \u0126ello Worl\u014A | ello Worl | Ħello WorlŊ |
SELECT 4