SQLite Forum

Command Line Shell set parameter as date
Login
I couldn't help experimenting a little:

```
▶▶▶ .param init
▶▶▶ .param set :bond "'007'"
▶▶▶ .param list
:bond 7
```
Uh-oh. What happened to the double-oh in double-oh seven? Well, it seems the answer lies here:

```
▶▶▶ .schema sqlite_parameters
CREATE TABLE temp.sqlite_parameters(
  key TEXT PRIMARY KEY,
  value ANY
) WITHOUT ROWID;
```

Which raises the question: Why was the type of the value here specified as `ANY`, which by the rules given in [section 3.1 of the Datatypes doc](https://sqlite.org/datatype3.html#determination_of_column_affinity) means it has `INTEGER` affinity? Was it intentional?