On 11/26/2011 05:02 AM, Nico Williams wrote:
You can CAST TEXT to BLOB, and you can use x'' for literal BLOBs.
You can. The result of which is a blob that corresponds to
either the utf-8 or utf-16 (big or little endian) encoding
of the text, depending on the encoding used by the database
file.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 25/11/11 20:34, Senthil_25 wrote:
> Just want to know whether sqlite support for gemotric column types?
The Rtree extension distributed with SQLite will likely meet your needs:
http://www.sqlite.org/rtree.html
Roger
-BEGIN PGP
Hi,
I am new to sqlite.
Just want to know whether sqlite support for gemotric column types?
Please Help me...
--
View this message in context:
http://old.nabble.com/sqlite-support-for-geometric-column-types--tp32876624p32876624.html
Sent from the SQLite mailing list archive at Nabble.com.
On Thu, Nov 24, 2011 at 05:22:38PM +, Simon Slavin scratched on the wall:
> On 24 Nov 2011, at 5:10pm, Jay A. Kreibich wrote:
> > On Thu, Nov 24, 2011 at 08:08:12AM +, Simon Slavin scratched on the
> > wall:
> >
> >> It is faster to search integers than it is to search real numbers.
> >
You can CAST TEXT to BLOB, and you can use x'' for literal BLOBs.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
I'd like to store any data as binary in my sqlite database, I approached
the problem by trying to hex() the input because the x' ' operator accepts
hex and outputs binary, for example:
x'hex("hello world")'
but that syntax doesn't work, is there any way to make storing any data as
its binary
Thanks for the tip for doing hex() on the results.
My function wasn't returning what I expected due to sqlite3_result_text16
taking bytes not characters.
it now works fine.
Soundfaction wrote:
>
> I have a situation where I get different results for this:
>
> select ... where
7 matches
Mail list logo