Re: [sqlite] efficacy of indexing a blob

2007-04-05 Thread Dennis Cote
Andrew Finkenstadt wrote: It would appear that SQLite supports indexing every data type. What would the efficienty of the index by if I indexed a binary data column? Similarly, if I wanted to have a datatype which was the equivalent of "RAW" (non-interpreted text), it would appear I want to

[sqlite] efficacy of indexing a blob

2007-04-05 Thread Andrew Finkenstadt
It would appear that SQLite supports indexing every data type. What would the efficienty of the index by if I indexed a binary data column? Similarly, if I wanted to have a datatype which was the equivalent of "RAW" (non-interpreted text), it would appear I want to create a database using UTF-8