You don´t undertand me, maybe my poor english.
I will try to show with examples in the sqlite command line.
create table test("Full Name" varchar(30), "Login" varchar(15), Age integer);
insert into test ("Full Name", "Login", Age) values ("Enrique Esquivel",
"the_kique", 24);
.headers on
select * from test;
SQLite returns:
Full Name|Login|Age
Enrique Esquivel|the_kique|24
But when write:
select "Full Name", "Login", Age from test;
returns:
"Full Name"|"Login"|Age
Enrique Esquivel|the_kique|24
Moreover when quote all fields:
select "Full Name", "Login", "Age" from test;
returns:
"Full Name"|"Login"|"Age"
Enrique Esquivel|the_kique|24
Also:
select [Full Name], [Login], [Age] from test;
SQLite returns wrong:
"Full Name"|"Login"|"Age"
Enrique Esquivel|the_kique|24
The quotes should be used for SQLite only for understand the identifiers, the
fields in result must be unquoted. Try to test with other dbms and anyone has
this behavior.
