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

    Fixed-length field values in xxx01/tab/tag_values.lng (loaded into Z112), sorting of special characters wrong

    • Article Type: General
    • Product: Aleph
    • Product Version: 21

    Problem Symptoms:

    When using the new table xxx01/tab/tag_values.lng in order to add for e.g. places of publication the sorting in the provided list in GUI is not as expected for German umlauts and other special characters.

    Loading of fixed-length field values into Z112 is done using "Import Database Tables - With Checks (file-06)".


    Resolution:

    Solved with rep_change 2546 in Aleph 21:
    Description: CAT - The description in a list of values for fixed fields (from tag_values.lng, loaded to Z112) was not properly sorted for values containing diacritics. For example, "e" with accent or diaeresis (umlaut) was after "z" instead of being together with non-accented "e".
     
    Solution: This has been corrected. A new character conversion type has been introduced for sorting properly the values in Z112 from tag_values.lng - "SORT-Z112". See Implementation Notes for more details.

     

    Implementation Notes:

    In order to sort diacritics in the right order for fixed fields lists of values, add in ./alephe/unicode/tab_character_conversion_line a line with type "SORT-Z112", using a table in which the diacritics have fallback characters without diacritics. For example:

    SORT-Z112 ##### # line_utf2line_utf unicode_to_word_gen

     

    Additional Information

    For further information about table z112 refer to article 'What is the z112 table'

     


    • Article last edited: 04/12/2016