> 1 bit sign (1= non-negative, 0= negative) First time I ever saw a number where... | Hacker News

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

		josefx on Oct 6, 2020 \| parent \| context \| favorite \| on: Time for a WTF MySQL Moment > 1 bit sign (1= non-negative, 0= negative) First time I ever saw a number where the leading sign bit has to be set to 1 to indicate non-negative.

js2 on Oct 6, 2020 | [–]

https://en.wikipedia.org/wiki/Offset_binary

jnwatson on Oct 6, 2020 | [–]

Sorts better that way.

karmakaze on Oct 6, 2020 | [–]

It would binary sort weird with negatives < 0 < positives but would put the largest magnitude negative closest to 0.

Also not Offset binary which uses 0111 for -1 rather than MySQL's 0001.

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