Am I missing something here? Postgres does allow you to choose character collati... | Hacker News

Hacker News .hnnew | past | comments | ask | show | jobs | submit

spprashant on May 12, 2023 | parent | context | favorite | on: Ask HN: It's 2023, how do you choose between MySQL...

Am I missing something here? Postgres does allow you to choose character collation when creating a database, as well as when creating new columns.

bkuehl on May 12, 2023 [–]

I'm sorry, I was wrong in that Postgres does let you specify a few character collations at the DB level, but they are pretty much ASCII vs UNICODE with no case-insensitive configurations. You can create collations in v12 and assign them to particular columns.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact