Title Capitalization in Grid

[Fred Slota]

Scrolling through a Search Grid (Cover Artist "Arthur Adams", if you're curious to replicate), and my eye was caught by a shift in the data in the grid.  Scroll back to identify it, and I find that amidst multiple issues with the Title "Guardians Of the Galaxy (4th Series)", one (Bk 5/HC) has the Title "Guardians of the Galaxy (4th Series)".  

I'm guessing that the Issues Table carries a full spelled out text field for the book Title, which should coordinate with the Official Title field in the Title Table, which in addition to being wasteful in space, is inconsistent in that it is not forced to match?

[Steven L. Dasinger]

I am not seeing what you are describing. In my database, Guardians of the Galaxy (4th series) has a lower-case 'o' in 'of'.

I have done a Find on Series title (lower-case), Issue title (lower-case), a Find for cover artist Arthur Adams and they are all lower-case.

I scroll down, one line at a time and the display at the top is always lower-case (even on Bk/HC).

Either our databases are not the same or I am missing something.

[Fred Slota]

 

My eye was drawn to the one-off difference as I was scrolling.  Ironically, the one-off is what should be the correct capitalization, yes?

This is probably related to my earlier X-Men '92: House of XCII posting, as it is odd capitalization of title in a search grid.

[Steven L. Dasinger]

Weird. Mine are lower-case.

[Fred Slota]

Question, is the database structured as I guessed at above, that rather than having the spelled-out title once, as a field in the Title Table, that the Issues Table has a separate highly repetitious and open to inconsistancies Title Field?

[Steven L. Dasinger]

Probably. I am going to assume a non-DBA designed the tables and they are not normalized.

There are a few Title columns (Title, Display Title, Alphabetized (sort) Title).