[Interactive SQL] error when writing characters to char

Przemek · #1 (**permalink**) 05-25-11, 13:28

I can't write a string to char(20) or the long varchar?

using:

Code:

INSERT
INTO movie (id_film, title, director, description, wymaganywiek, genre, price)
VALUES (3, a, 7, 22.50,78, 56, 87)

crashes me an error: "error at line 1: column 'a' not found"

while:

Code:

INSERT
INTO movie (id_film, title, director, description, wymaganywiek, genre, price)
VALUES (3, 7, 7, 22.50,78, 56, 87)

is well.

and the title is a char (20)?

Przemek · #2 (**permalink**) 05-25-11, 14:09

I found solution, I should used 'a' with quotes instead of a.