Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    Bib_text.title has incorrect 0x1F

    • Product: Voyager
    • Product Version: 7.0.2
    • Relevant for Installation Type: Total Care; Dedicated-Direct; Direct; Local

    Symptoms

    • Bib records incorrectly parsed when content is placed into the bib_text.title column
    • Subfield delimiter value (0x1F) not being filtered, and small boxes appear in the bib_text at the top of record display in Cataloging client (and as question mark in WebVoyage).

    Defect Status

    Issue 16384-5137 / VYG-4664 is resolved in Voyager 10.1.0

    Replication steps

    1. Import bib record in Cataloging
    2. Save.
    3. Note that the 2nd indicator is 5
    4. Look at the top of the screen and see the small box between subfield a and subfield b. 
    5. Do a dump from bib_text and note the 0x1F is not being filtered out:
    SQL> select dump(title, 1016) as dmp from bib_text where bib_id =62328;
    DMP
    --------------------------------------------------------------------------------
    Typ=1 Len=196 CharacterSet=US7ASCII: 4d,6f,cc,84,74,65,61,74,65,61,20,3a,1f,20,6
    8,65,20,6d,61,72,61,6d,61,72,61,20,72,65,72,65,20,6e,6f,cc,84,20,6e,67,61,cc,84,
    20,77,61,6b,61,20,6d,61,68,61,20,2f,20,68,65,20,6d,65,61,20,6b,6f,68,69,6b,6f,68
    ,69,20,6e,61,cc,84,20,53,69,72,20,41,70,69,72,61,6e,61,20,4e,67,61,74,61,3b,20,5
    0,61,72,74,20,49,20,3d,20,54,68,65,20,73,6f,6e,67,73,20,3a,20,73,63,61,74,74,65,
    72,65,64,20,70,69,65,63,65,73,20,66,72,6f,6d,20,6d,61,6e,79,20,63,61,6e,6f,65,20
    ,61,72,65,61,73,20,2f,20,63,6f,6c,6c,65,63,74,65,64,20,62,79,20,53,69,72,20,41,7
    0,69,72,61,6e,61,20,4e,67,61,74,61,3b,20,50,61,72,74,20,31,2e,20
    1. Change second indicator to 0
    2. Look at top of screen and see that small box between subfield a and subfield b is now gone. 
    3. Do a dump from bib_text and note 0x1F is now being filtered out correctly. 
    SQL> select dump(title, 1016) as dmp from bib_text where bib_id =62328;
    DMP
    --------------------------------------------------------------------------------
    Typ=1 Len=201 CharacterSet=US7ASCII: 4e,67,61,cc,84,20,6d,6f,cc,84,74,65,61,74,6
    5,61,20,3a,20,68,65,20,6d,61,72,61,6d,61,72,61,20,72,65,72,65,20,6e,6f,cc,84,20,
    6e,67,61,cc,84,20,77,61,6b,61,20,6d,61,68,61,20,2f,20,68,65,20,6d,65,61,20,6b,6f
    ,68,69,6b,6f,68,69,20,6e,61,cc,84,20,53,69,72,20,41,70,69,72,61,6e,61,20,4e,67,6
    1,74,61,3b,20,50,61,72,74,20,49,20,3d,20,54,68,65,20,73,6f,6e,67,73,20,3a,20,73,
    63,61,74,74,65,72,65,64,20,70,69,65,63,65,73,20,66,72,6f,6d,20,6d,61,6e,79,20,63
    ,61,6e,6f,65,20,61,72,65,61,73,20,2f,20,63,6f,6c,6c,65,63,74,65,64,20,62,79,20,5
    3,69,72,20,41,70,69,72,61,6e,61,20,4e,67,61,74,61,3b,20,50,61,72,74,20,31,2e,20
    1. When second indicator is 4 (landing on the diacritic) or higher (indicators landing on or passing the diacritic), issue occurs.

    • Article last edited: 04-Mar-2015