Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Voyager

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Voyager
    3. Knowledge Articles
    4. Maximum length of MARC records in Voyager

    Maximum length of MARC records in Voyager

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Question
    2. Answer
    3. Additional Information
    • Product: Voyager
    • Relevant for Installation Type: Multi-Tenant Direct, Dedicated-Direct, Local, TotalCare

     

    Question

    What is the maximum MARC record length in Voyager?

    Answer

    MARC 21 records have a maximum length of 99999 characters. This applies to both BIBs and MFHDs. This is the largest number that can be entered in the MARC 21 Logical Record Length field (Leader, character positions 00-04).

    There have been reports from customers of issues with records exceeding 95,000 bytes.

    Since the MARC record length is a 5-byte field, it's not possible for the length to exceed 99,999.

    Additional Information

    The following Prepackaged Access Reports queries might help you to identify records approaching this limit:

    This is a query for MFHDs longer than 95,000 bytes:

    SELECT MFHD_DATA.MFHD_ID, Mid([RECORD_SEGMENT],1,5) AS RecLeng
    FROM MFHD_DATA
    WHERE (((MFHD_DATA.SEQNUM)="1") AND ((Mid([RECORD_SEGMENT],1,5))>'95000'));

    This is a query for BIBs longer than 95,000 bytes:

    SELECT BIB_DATA.BIB_ID, Mid([RECORD_SEGMENT],1,5) AS RecLeng
    FROM BIB_DATA
    WHERE (((BIB_DATA.SEQNUM)="1") AND ((Mid([RECORD_SEGMENT],1,5))>'95000'));

     

    Constructing custom SQL queries by request and troubleshooting unexpected results from customer-created SQL queries falls outside the scope of Support. The above has been posted for informational purposes.  Voyager-L and Developer Network are useful resources for finding helpful custom SQL or obtaining assistance from peers in troubleshooting custom queries.

     


    • Article last edited: 15-Sept-2021
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Match Job gives message "Mismatch between the encoding specified and the actual encoding leader byte of the source file" in GDC
      • Maximum number of Related Records to display in Voyager OPAC
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Voyager
    2. Tags
      This page has no tags.
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved