What type should I use to store emoji in PostgreSQL?

Viewed 12663

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?

1 Answers

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

Related