On 28 Aug 2018, at 15:36, Keith Medcalf wrote:
> On Tuesday, 28 August, 2018 07:50, Tim Streater wrote:
>>How does it know not to do that if I want to send some binary data to a Text
>>column?
>
> Simply because you do not request that those things be done.
>
> So, the "things" that may occur
On Tuesday, 28 August, 2018 07:50, Tim Streater wrote:
>What is actually the difference between a column declared as TEXT and
>one declared as BLOB in an SQLite database?
Not a thing. You are free to store data of any type in any column in any row.
The "TEXT" declaration only means that
Ah great to know. Thanks!
Ben
On Tue, Aug 28, 2018 at 7:29 AM Richard Hipp wrote:
> On 8/28/18, Ben Asher wrote:
> > I seem to remember that BLOBs cannot be indexed. I can’t find
> documentation
> > on that though. Does anyone else recall the same thing and have a link,
> or
> > maybe someone
On 8/28/18, Ben Asher wrote:
> I seem to remember that BLOBs cannot be indexed. I can’t find documentation
> on that though. Does anyone else recall the same thing and have a link, or
> maybe someone can correct me?
You might be remembering the limitations of Oracle. Other database
engines
On 28 Aug 2018, at 2:50pm, Tim Streater wrote:
> What is actually the difference between a column declared as TEXT and one
> declared as BLOB in an SQLite database? What does SQLite do to textual data
> that I ask it to put into a TEXT column?
BLOB data is always handled as a block of a
On 2018-08-28 09:50:01, "Tim Streater" wrote:
What is actually the difference between a column declared as TEXT and
one declared as BLOB in an SQLite database? What does SQLite do to
textual data that I ask it to put into a TEXT column? How does it know
not to do that if I want to send some
I seem to remember that BLOBs cannot be indexed. I can’t find documentation
on that though. Does anyone else recall the same thing and have a link, or
maybe someone can correct me?
Ben
On Tue, Aug 28, 2018 at 6:50 AM Tim Streater wrote:
> What is actually the difference between a column
What is actually the difference between a column declared as TEXT and one
declared as BLOB in an SQLite database? What does SQLite do to textual data
that I ask it to put into a TEXT column? How does it know not to do that if I
want to send some binary data to a Text column?
The reason I'm
8 matches
Mail list logo