On Tue, May 19, 2009 at 12:49 PM, John Machin <sjmac...@lexicon.net> wrote:
> It's handy for checking how things work e.g.
>
> sqlite> select (-1) % 7;
> -1
> sqlite> -- it's not a real modulo operator :-(
I also used it as:
sqlite> .mode col
sqlite> .h 1
sqlite> select "€", length("€"), length(cast("€" as blob)), hex("€");
"€" length("€") length(cast("€" as blob)) hex("€")
---------- ------------- --------------------------- ----------
€ 1 3 E282AC
To make sure the sqlite shell was inserting UTF-8 as it should.
Regards,
~Nuno Lucas
>
> Cheers,
> John
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
