Gavin Kistner wrote: > > Not only that...look at the values! > Oh yeah! I missed that. For the benefit of others.
SQLite version 3.6.2 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> create table t (`a`, ```a```); sqlite> insert into t values (1,2); sqlite> .headers on sqlite> .mode column sqlite> select * from t; a a ---------- ---------- 1 1 sqlite> pragma table_info(t); cid name type notnull dflt_value pk ---------- ---------- ---------- ---------- ---------- ---------- 0 a 0 0 1 `a` 0 0 From the table_info you can see that SQLite knows the correct name of the second column, but it doesn't display the correct name, or the correct value for the select * query. >> Have you filed a bug report to see in any of these can be resolved? > I will file a bug report for this one. Dennis Cote _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
