I think I understand now and I'm using SQLite Studio. It appears SQLite Studio
is acting as a enhanced wrapper around SQLite3. I did some reading and there
is a SQLite Studio manual with with a list of 16 data types and it looks as if
you can configure editors around those data types. I probably need to be apart
of that forum for this question.
Thanks for the help! I appreciate the patience until my thick head could be
penetrated :)
16 (17) Data
Types:https://github.com/pawelsalawa/sqlitestudio/wiki/User_Manual#value-editor-dialog
Scott ValleryEcclesiastes 4:9-10
On Tuesday, February 5, 2019, 10:44:40 AM EST, Simon Slavin
<[email protected]> wrote:
On 5 Feb 2019, at 3:29pm, Scott <[email protected]> wrote:
> Thanks for the timely response. I provided below the details. "Time(8)" is
> the generated description of the structure defined by SQLite3 based upon Data
> Type options. So I apologize if I don't understand you comment.
SQLite didn't generate "Time(3)". Some other piece of software may have done
so, and told SQLite to use it as a datatype.
SQLite doesn't have a Time datatype. See the list of datatypes at the top of
section 2 of
<https://www.sqlite.org/datatype3.html>
SQLite is taking "Time(8)" and understanding it as "TEXT". See the table in
section 3.1.1 of the above web page.
SQLite doesn't recognise limits to the number of characters in text fields.
SQLite is ignoring the "(8)" giving it a limit of 8 characters. See the
paragraph just above that table.
Hope this helps.
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
