SQLite4

Check-in [b1ae0ca8c3]

Check-in [b1ae0ca8c3]

Many hyperlinks are disabled.

Use anonymous login
to enable hyperlinks.

Overview

Comment: | Fix a typo on the key-encoding documentation. |
---|---|

Downloads: | Tarball | ZIP archive | SQL archive |

Timelines: | family | ancestors | descendants | both | trunk |

Files: | files | file ages | folders |

SHA1: |
b1ae0ca8c3f93cb92c78d76f2c25cc91 |

User & Date: | drh 2013-01-20 02:38:46 |

Context

2013-01-20
| ||

02:52 | Fix typos in the VARINT documentation. check-in: eccdf70b22 user: drh tags: trunk | |

02:38 | Fix a typo on the key-encoding documentation. check-in: b1ae0ca8c3 user: drh tags: trunk | |

00:07 | Enable the AUTOINCREMENT feature. check-in: 5442b20bf6 user: drh tags: trunk | |

Changes

Changes to www/key_encoding.wiki.

88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 |
If the numeric value is a positive infinity then the encoding is a single byte of 0x23. Every other numeric value encoding begins with a smaller byte, ensuring that positive infinity always sorts last among numeric values. 0x0d is also smaller than 0x0e, the initial byte of a text value, ensuring that every numeric value sorts before every text value. If the numeric value is exactly zero then then is encoded is a single byte of 0x15. Finite negative values will have initial bytes of 0x08 through 0x14 and finite positive values will have initial bytes of 0x16 through 0x22. For all values, we compute a mantissa M and an exponent E. The mantissa is a base-100 representation of the value. The exponent E determines where to put the decimal point. |
| |
88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 |
If the numeric value is a positive infinity then the encoding is a single byte of 0x23. Every other numeric value encoding begins with a smaller byte, ensuring that positive infinity always sorts last among numeric values. 0x0d is also smaller than 0x0e, the initial byte of a text value, ensuring that every numeric value sorts before every text value. If the numeric value is exactly zero then it is encoded as a single byte of 0x15. Finite negative values will have initial bytes of 0x08 through 0x14 and finite positive values will have initial bytes of 0x16 through 0x22. For all values, we compute a mantissa M and an exponent E. The mantissa is a base-100 representation of the value. The exponent E determines where to put the decimal point. |