Description

We are unable to search for a particular bib record (014030881) by title.  The record contains various special characters/diacritics.

Resolution

The following SQL shows all of the ACC Browse index (z01) entries for this bib record:

xxx01@ALEPH0> select z01_rec_key from z01, z02 where z01_acc_sequence = substr (z02_rec_key,1,9) and Z02_DOC_NUMBER = '014030881';

Try retrieving the record by the title index codes (TTL, TIx, TTLx, TIxx, etc.) shown in the results.  If the z01_rec_key is incorrect, then take the filing procedure (specified in column 5 of the relevant xxx01 tab00.lng entries) and examine the xxx01 tab_filing table lines for this filing procedure.  Noting in particular any 

11 N char_conv            FILING-KEY-nn

lines.  

The tab_filing header has the following info for char_conv:

! - char_conv: perform character conversion procedure according
!              to the procedure name listed in col.4. This name must
!              match procedure identification in col.1 of
!              /alephe/unicode/tab_character_conversion_line

For example, if tab_filing col. 4 has  "FILING-KEY-10", then the relevant line in tab_character_conversion_line is "FILING-KEY-10".

• Article last edited: 1-Nov-2017