What type should I use to store emoji in PostgreSQL?

Question

I am working with Postgres and newbie too,

I have to store the user's comment (like facebook comment) into database. probably I will use column type "text" to store the comment.

If in case the comment is mixed up with emojis (unicode), the text type is enough or I should use any other column type?

I've got a `invalid byte sequence for encoding "UTF8": 0xed 0xb3 0xa9` even with a `text` type... — DestyNova, Jun 30 '16 at 11:20
@DestyNova that appears to be a unicode error. Try specifying the encoding before your operation http://stackoverflow.com/a/23794054/845598 — Anconia, Feb 02 '17 at 13:49
If you get this error while using PHP, don't forget tu use the "mb_" family string functions. — COil, Apr 02 '20 at 09:16

score 9 · Answer 1 · answered Feb 15 '19 at 22:41

9

The TEXT "character" type should be fine as UTF-8, generally, is a supported character set.

answered Feb 15 '19 at 22:41

Anthony Mastrean

and how to store emogis on that table? – A l w a y s S u n n y Mar 05 '22 at 03:27

1 Answers1