######octothorp.es

#unicode

  • Always use the C Locale with PostgreSQL

    https://justatheory.com/2004/08/postgres-always-use-c-locale/

  • Unicode Normalization in SQL

    https://justatheory.com/2009/09/postgres-unicode-normalization/

  • CITEXT Patch Submitted to PostgreSQL Contrib

    https://justatheory.com/2008/06/citext-patch-submitted/

    On Friday, I submitted a patch to add a locale-aware case-insensitive text type as a PostgreSQL contrib module. This has been among my top requests as a feature for PostgreSQL ever since I started using it. And as I started work on yet another application recently, I decided to look into what it would take to just make it happen myself. I’m hopeful that everyone will be able to benefit from this bit of yak shaving.

    Follow #unicode on RSS or use the

    JSON API
    
    curl -X GET \
      -H "Content-type: application/json" \
      -H "Accept: application/json" \
      "https://octothorp.es/~/unicode"