Results 1 to 2 of 2
  1. #1
    Join Date
    May 2011
    Posts
    1

    Unanswered: [Interactive SQL] error when writing characters to char

    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)?

  2. #2
    Join Date
    May 2011
    Posts
    1
    I found solution, I should used 'a' with quotes instead of a.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •