SQLite

Artifact 5252350d11b0c55aace1ab2c7925502612ade3e8:

Attachment "bug536662_test.sqlite" to ticket [6c266900] added by nobody 2013-01-02 04:43:22. (unpublished)

---

.header on

create table tbl1 (col1 text primary key);

insert into tbl1 values ('123456');
insert into tbl1 values ('abcdef');
insert into tbl1 values ('äöüäöü');

select col1 from tbl1;
select substr(col1, 1, 4) as col1 from tbl1;

.mode column
select col1 from tbl1;

.width 4
select col1 from tbl1;