vendredi 25 mars 2016

Sqlit3 not accepting blank spaces in input

I have a table trails in sqlite3 database (that is dealing with bike trails whose schema is:

CREATE TABLE trails (ID integer primary key, name text, city text, state char(2), length integer, ascent integer, difficulty char(2), description text);

And then I try and insert a value into it:

INSERT INTO trails (name, city, state, length, ascent, difficulty, description) VALUES (‘Blue'Sky’,‘Fort Collins’,‘CO’, 6, 300, ‘bg’, ‘cool trail’);

I thought that the data type text would take any kind of string given (even those with strings, such as a paragraph). What is going wrong?

Aucun commentaire:

Enregistrer un commentaire