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 d
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 the
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 might
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 certa
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 b
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 declare
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 inte
8 matches
Mail list logo