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

    Displaying diacritics in SQL reports

    • Article Type: Q&A
    • Product: Aleph
    • Product Version: 20
    • Relevant for Installation Type: Dedicated-Direct; Direct; Local;

    Question

    When running reports in SQL, diacritics are not displaying properly.

    The NLS_LANG in aleph_start is set to American_America.UTF8

    Is it possible to get the character sets that p-manage-22 (the "Character conversion" service) converts from UTF to whatever? This would allow CONVERT to be used in SQL statements.

    Answer

    The conversion tables that p_manage_22 uses are all in the ./alephe/unicode directory, and the file tab_character_conversion_line specifies which table will be used. It is unlikely that SQL could use these tables, as it has its own tables.

    CONVERT can be used with SQL query SELECT statements (e.g.):
    SELECT CONVERT(Z13_TITLE, 'WE8ISO8859P1', 'UTF8'), z13_CALL_NO, etc.

    Settings for different languages can be found at:
    http://docs.oracle.com/cd/B28359_01/server.111/b28298/applocaledata.htm#i635016


    • Article last edited: 10/8/2013