search

max-elixir / MovieManager

Movie Manager is a web and/or android-based application that assists movie theater staff in maintaining and building a movie schedule. Group project for a Database Systems class.
0 stars 0 forks source link

Quotations take up extra characters. We should probably expand the character limit for some values #5

Closed Jason-Kha closed 5 years ago

Jason-Kha commented 5 years ago

Quotations take up extra characters. We should probably expand the character limit by a little bit for titles, filmtypes, and genres.

film.txt: 0, 'Avengers: Endgame', 3.0, 'movie', 'superhero', 300.00 1, 'Spiderman: Far From Ho', 0.05, 'trailer', 'superhero', 50.00 2, 'Toy Story 4', 0.05, 'trailer', 'Family', 50.00 3, 'Hellboy (2019)', 2.0, 'movie', 'action', 200.00 4, 'Little', 1.5, 'movie', 'comedy', 200.00

Example: film type ('trailer') is 9 characters, but max is 7 based on the sql table film.log: Record 2: Rejected - Error on table FILM, column FILMTYPE. ORA-12899: value too large for column "ZKI628"."FILM"."FILMTYPE" (actual: 9, maximum: 7)

Record 3: Rejected - Error on table FILM, column FILMTYPE.
ORA-12899: value too large for column "ZKI628"."FILM"."FILMTYPE" (actual: 9, maximum: 7)

Originally posted by @Jason-Kha in https://github.com/max-elixir/MovieManager/issues/2#issuecomment-483449916

Jason-Kha commented 5 years ago

Turns out the quotations did nothing at all, just took up an extra two character spaces. Not sure how to handle chars with commas in them, though.