-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
I think I found a small glitch or, maybe, consider it a request for
enhancement ;-)
% sqlite3 prova
SQLite version 3.2.5
Enter ".help" for instructions
sqlite> CREATE TABLE a(b);
sqlite> INSERT INTO a VALUES (X'41424300500051');
sqlite> .dump
BEGIN TRANSACTION;
CREATE TABLE a(b);
INSERT INTO "a" VALUES(X'41424300500051');
COMMIT;
sqlite> .mode insert
sqlite> SELECT * FROM a;
INSERT INTO table VALUES('ABC');
It would be nice for ".mode insert" to print a command that would
actually re-create the same data, the same as ".dump" (the obvious
difference is that .dump can't filter data in any way, it just dumps
it all) or, at least, it would be very nice if the already existing
function that "prints binary data as X'-encoded-string" were reachable
from SQL, so that one could use something like:
SELECT xencode(b) FROM a;
and obtain
X'41424300500051'
Lapo
PS: I prefer to read the ML from gmane newsgroup interface, is there
any way I can be added to the people that can post without actually
needing to receive the emails also?
- --
L a p o L u c h i n i
l a p o @ l a p o . i t
w w w . l a p o . i t /
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (Cygwin)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iEYEARECAAYFAkMzy2sACgkQaJiCLMjyUvucQwCg3qVABfQAdoaViiDypL/kjoEi
aVEAoO8HDKElCdWbqhDG6wlC2ed9f0qW
=dFDl
-----END PGP SIGNATURE-----
