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 SQLite Expert (Or if Bogdan is watching)
could offer a hint to whether or not my software will require special
requirements to make absolute certain that the full amount of text I'm
entering is inserted properly.
I'm just trying to understand if there is ever going to be a potential
limitation on data entry using a standard insert/update command versus my
having to convert what I'm inserting into the "X" prefixed-hex-type.
Honestly, the GUI component I'm using I believe is limited to 65k worth of
text, but that was in the Delphi 5 days, and I'm unsure if Berlin has
changed that limitation.
On Tue, Feb 20, 2018 at 11:35 AM, Richard Hipp <d...@sqlite.org> wrote:
> 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-Expert authors think it should function, rather than
> how it actually functions. So your theory of the difference in output
> being due to shenanigans perpetrated by SQLite Expert might be
> correct, for all I know.
>
> The sqlite3.exe program, on the other hand, is an officially supported
> product, developed by and for the core SQLite developers. SQLite3.exe
> behaves as the SQLite core developers intend SQLite to behave.
>
> All that said, I'm not exactly sure what you are asking.....
>
> On 2/20/18, Stephen Chrzanowski <pontia...@gmail.com> wrote:
> > 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 "Test 2". I'm also fine with that.
> >
> > 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 Expert is not doing and just shows (blob).
> >
> > The reason I'm asking is that I've got an application that handles bulk
> > text inserts, and I want to make sure that I don't run into some kind of
> > stupid (My code, not SQLite) limitation that'd chop text out, or what
> have
> > you.
> >
> > On Tue, Feb 20, 2018 at 11:17 AM, Stephen Chrzanowski <
> pontia...@gmail.com>
> > wrote:
> >
> >> I'm fully aware that any kind of data can be stored in any kind of
> field.
> >> Strings can be in integer declared fields, etc.
> >>
> >> 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.
> >>
> >> In "SQLite Expert", if I declare a field as BLOB or BLOB_TEXT, the UI
> >> itself "hides" the information pending certain declaration types on the
> >> tables field. SQLITE3.EXE does not.
> >>
> >> Case in point:
> >>
> >>
> > _______________________________________________
> > sqlite-users mailing list
> > sqlite-users@mailinglists.sqlite.org
> > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> >
>
>
> --
> D. Richard Hipp
> d...@sqlite.org
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
