Re: [sqlite] SQLite truncating long records for text-type fields.

2018-07-06 Thread Richard Hipp
On 7/5/18, Jeffrey Mumford wrote: > > It appears that when querying from long text fields, sqlite assumes the > first instance of the field is the length of all subsequent fields. When you use ".mode column", it has to make some assumptions along those lines. I suggest you set ".mode quote" or

Re: [sqlite] SQLite truncating long records for text-type fields.

2018-07-06 Thread Richard Hipp
On 7/5/18, Jeffrey Mumford wrote: > Version info: > > -- Loading resources from /root/.sqliterc Can you please show us what you have set inside of /root/.sqliterc? > SQLite version 3.14.2 2016-09-12 18:50:49 > Enter ".help" for usage hints. > > Issue: > > It appears that when querying from

[sqlite] SQLite truncating long records for text-type fields.

2018-07-06 Thread Jeffrey Mumford
Version info: -- Loading resources from /root/.sqliterc SQLite version 3.14.2 2016-09-12 18:50:49 Enter ".help" for usage hints. Issue: It appears that when querying from long text fields, sqlite assumes the first instance of the field is the length of all subsequent fields. The result is