view release on metacpan or  search on metacpan

lib/DBD/SQLite/BundledExtensions.pm  view on Meta::CPAN

This module implements the spellfix1 VIRTUAL TABLE that can be used
to search a large vocabulary for close matches.  See separate
documentation (http://www.sqlite.org/spellfix1.html) for details.

=item totype 

This SQLite extension implements functions tointeger(X) and toreal(X).

If X is an integer, real, or string value that can be
losslessly represented as an integer, then tointeger(X)
returns the corresponding integer value.
If X is an 8-byte BLOB then that blob is interpreted as
a signed two-compliment little-endian encoding of an integer
and tointeger(X) returns the corresponding integer value.
Otherwise tointeger(X) return NULL.

If X is an integer, real, or string value that can be
convert into a real number, preserving at least 15 digits
of precision, then toreal(X) returns the corresponding real value.
If X is an 8-byte BLOB then that blob is interpreted as