[Koha-bugs] [Bug 7715] Add biblio.subtitle and appropriate mappings to MARC frameworks

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7715

Marijana Glavica <mglavica at ffzg.hr> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |mglavica at ffzg.hr

--- Comment #5 from Marijana Glavica <mglavica at 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.