[Koha-bugs] [Bug 29533] add more fields to items sql table

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29533

--- Comment #2 from mathieu saby <mathsabypro at gmail.com> ---
Hi
Even with only lowercases in 952/995, do you believe that the idea of allowing
more subfields to be mapped in SQL is a bad idea?

But I think uppercases are allowed in UNIMARC for subfields in local (9XX)
fields, and I doubt it is forbidden in MARC21.

For Marc21 the alphabetic character must be lowercase:

Subfield codes - Two characters that distinguish the data elements within a
field which require separate manipulation. A subfield code consists of a
delimiter (ASCII 1F hex), represented in this document as a $, followed by a
data element identifier. Data element identifiers may be a lowercase alphabetic
or a numeric character. 
https://www.loc.gov/marc/bibliographic/bdintro.html

But there is no such precision for UNIMARC:
Subfield Identifier – A code consisting of two characters identifying
individual subfields within a variable field. The first character, the
delimiter, is always the same unique character specified in ISO 2709 and the
second character, the subfield code, is either numeric or alphabetic
https://eprints.mdx.ac.uk/2655/1/UNIMARC-2008-AH_final.pdf


And in marcXML schema you can read this, so it seems that uppercase are allowed
in MARC21 for local data
https://www.loc.gov/standards/marcxml/schema/MARC21slim.xsd

"May 21, 2009 - Version 1.2 - in subfieldcodeDataType the pattern
"[\da-z!"#$%&'()*+,-./:;<=>?{}_^`~\[\]\\]{1}" changed to:
"[\dA-Za-z!"#$%&'()*+,-./:;<=>?{}_^`~\[\]\\]{1}" i.e "A-Z" added after "[\d"
before "a-z" to allow upper case. This change is for consistency with the
documentation. ************************************************************
This schema supports XML markup of MARC21 records as specified in the MARC
documentation (see www.loc.gov). It allows tags with alphabetics and subfield
codes that are symbols, neither of which are as yet used in the MARC 21
communications formats, but are allowed by MARC 21 for local data."

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.