Thanks all. I'll consider this thread done. With Ryan and Bills comments,
I've decided that I'll truck on as is, and not worry about special string
considerations.
Thinking about how Delphi Berlin is handling strings at the compiler level,
and how the wrapper I use is handling the strings based
> What I'm interested in finding out, without changing my code at this time, is
> if
> SQLITE3.EXE is handling things differently than what SQLite Expert is.
It absolutely is. I am a heavy user of SQLite Expert and was stumped by weird
problems in my databases until I realized the SQLite Expert
On 2018/02/20 6:35 PM, Richard Hipp wrote:
All that said, I'm not exactly sure what you are asking.
I had some trouble with that too, but I think his question boils down to:
Considering that SQLiteExpert is doing seemingly funny things under the
hood on top of SQLite, would those be safe
On 20 Feb 2018, at 4:21pm, Stephen Chrzanowski wrote:
> What I'm not entirely sure of is whether SQLite Expert is understanding and
> handling the BLOB_TEXT field and just not doing the actual query to get the
> text, or, if it understand if there is some kind of special handling that
> SQLite Ex
I'm absolutely clear that the SQLite3 developers have absolutely NOTHING to
do with SQLite Expert. I apologize if there was any indication that I was
thinking that I was asking for the devs of SQLite3 would have a direct
answer to how that 3rd party tool works.
My hope was that someone who uses S
At 17:35 20/02/2018, you wrote:
SQLite Expert, if I am not mistaken, does
try to do some magic under the hood to make SQLite function more like
how the SQLite-Expert authors think it should function, rather than
how it actually functions. So your theory of the difference in output
being due to s
One thing that it is important to be clear on is that SQLite Expert is
a 3rd-party product that is not supported nor even understood by the
official SQLite developers. SQLite Expert, if I am not mistaken, does
try to do some magic under the hood to make SQLite function more like
how the SQLite-Exp
sqlite.org] On
Behalf Of Stephen Chrzanowski
Sent: Tuesday, February 20, 2018 11:22 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Clarification on Storage
That was NOT supposed to happen. :P
CREATE TABLE [Test](
[ID] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
[T1] T
That was NOT supposed to happen. :P
CREATE TABLE [Test](
[ID] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
[T1] TEXT,
[T2] BLOB_TEXT);
insert into Test (T1,T2) values ('Test 1','Test 2');
In SQLite Expert, it hides "Test 2" as a (blob). I'm fine with that.
In SQLITE3.exe, it shows "T
9 matches
Mail list logo
