Re: [Monotone-devel] Re: silly question #2: why base64?

[Florian Weimer]

* Lapo Luchini:

> BTW: it's a shame sqlite3 supports INTEGER fields only up to 8 bytes, a
> big-integer-like field would have been very handy to use hashes in
> numeric form and have them transparently in binary in the DB.

I think you can do this with BLOBs.

| BLOB literals are string literals containing hexadecimal data and
| preceded by a single "x" or "X" character. For example:
| 
|   X'53514697465'

<http://www.sqlite.org/lang_expr.html>

Unfortunately, the sqlite3 command line client does not seem to be
able to output BLOB fields in a readable way.  But this could probably
be fixed upstream.