PlanetScale for Postgres is now GA

Re:PlanetScale for Postgres is now GA by sgarland on Monday September 22, 2025 @07:07PM (#45340736)

> (VAR)BINARY

Close [0]: (VAR)CHAR BINARY, which is its own type, uses the `_bin` collation for the column or table character set. (VAR)BINARY stores binary strings, and uses the `binary` character set and collation.

In fairness, the amount of options, gotchas, and WTF involved with collations in any DB is mind-boggling.

[0]: https://dev.mysql.com/doc/refman/8.4/en/binary-varbinary.htm...

[ Parent | on HN ]

Re:PlanetScale for Postgres is now GA by tracker1 on Tuesday September 23, 2025 @09:57AM (#45347128)

I just know that I was sitting converted uuid and was getting collisions on different binary values. This was admittedly a couple decades ago though.

By converted it was legacy records where the original int value was injected to uuid format. This was then stored in a binary field as a primary key.

[ Parent | on HN ]