> (VAR)BINARY Close [0]: (VAR)CHAR BINARY, which is its own type, uses the `_bin... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

sgarland 10 months ago | parent | context | favorite | on: PlanetScale for Postgres is now GA

> (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...

tracker1 10 months ago [–]

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.

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