Postgres Pro
Downloads
Home   >   mailing lists

badly calculated width of emoji in psql - Mailing list pgsql-hackers

From Pavel Stehule
Subject badly calculated width of emoji in psql
Date
Msg-id CAFj8pRCeX21O69YHxmykYySYyprZAqrKWWg0KoGKdjgqcGyygg@mail.gmail.com
Whole thread Raw
Responses Re: badly calculated width of emoji in psql  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-hackers
Tree view
Hi


postgres=# SELECT U&'\+01F603';
┌──────────┐
│ ?column? │
╞══════════╡
│ 😃        │
└──────────┘
(1 row)


The result is not correct. Emoji has width 2 chars, but psql calculates with just one char.

Regards

Pavel

pgsql-hackers by date:

Previous
From: Fujii Masao
Date:
Subject: Re: Data type correction in pgstat_report_replslot function parameters
Next
From: Fujii Masao
Date:
Subject: Re: Fix pg_checksums progress report