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
- 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