Bib_text.title has incorrect 0x1F

Last updated
Save as PDF
Share
1. Share
2. Tweet
3. Share

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

Import bib record in Cataloging
Save.
Note that the 2nd indicator is 5
Look at the top of the screen and see the small box between subfield a and subfield b.
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

Change second indicator to 0
Look at top of screen and see that small box between subfield a and subfield b is now gone.
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

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