What SQLite column name can be/cannot be?

Question

Is there any rule for the SQLite's column name?

• Can it have characters like '/'?
• Can it be UTF-8?

Answer 1

http://www.sqlite.org/lang_keywords.html that has a complete list! enjoy!

Answer 2

Can it have characters like '/'?

All examples are from SQlite 3.5.9 running on Linux.

If you surround the column name in single quotes, you can:

> CREATE TABLE test_forward ( /test_column INTEGER );
SQL error: near "/": syntax error
> CREATE TABLE test_forward ('/test_column' INTEGER );
> INSERT INTO test_forward('/test_column') VALUES (1);
> SELECT test_forward.'/test_column' from test_forward;
1

EDIT: dan04 is right, if you do this you should probably used double quotes instead. That said, you probably shouldn't do this.