http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7715 Marijana Glavica <mglavica@ffzg.hr> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |mglavica@ffzg.hr --- Comment #5 from Marijana Glavica <mglavica@ffzg.hr> --- The problem with having "subtitle" field in a database is that there is no such field in MARC21 nor in UNIMARC. MARC21 has 245$b - remainder of title (subtitle, paralel title, etc.) UNIMARC has 200$e - other title information (subtitle and other information subordinate to title proper) On the other hand, from the practical point of view, it is very tempting to have separate database filed for this, because in SQL reports title is often not enough. But than, for some cases, title + subtitle is also not enough because we also have multipart items so we need title and subtitle together with number of part and title of part. Keywords to MARC mapping is much nicer solution, but it is not usable in SQL reports. But than, for SQL reports we now can use MySQL XML handling function, so this is not so big problem as before MySQL 5.1.5 So in conclusion, I vote against having subtitle field in database. If we go (back) in that direction, the name of this field should not be subtitle. -- You are receiving this mail because: You are watching all bug changes.