S
S
Slevin Kelevra2014-03-04 11:26:15
bash
Slevin Kelevra, 2014-03-04 11:26:15

Why does SQLite3 truncate the output?

Good afternoon!
There is a base file.db, there is a database structure, all fields are VARCHAR (256).
But when you try to render SELECT * FROM table;, the data is displayed, but long lines are cut off.
It's not about terminal settings.
Question: how to make sqlite3 -column file.db "SELECT * FROM table;"sure that the data is not cut off.
PS the data in the database itself is in full form, i.e. full text.

Answer the question

In order to leave comments, you need to log in

2 answer(s)
G
gleb_kudr, 2014-03-08
@gleb_kudr

The (256) phrase after VARCHAR is ignored by SQLite because no size limits are set on its fields. Also, your database is unlikely to be larger than the limits .
Therefore, the problems are precisely in the software settings with which you are trying to display data. Try some other browser for the same database and run the request there.

S
Slevin Kelevra, 2014-03-08
@slevinkelevra

My software is bash ))
The request is written in the bash script.
Now, if I do -csv, then all fields are displayed as they should.
If I do -column, then everything is cut off.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question