Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. Displaying diacritics in SQL reports

    Displaying diacritics in SQL reports

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Question
    2. Answer
    • 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
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Displaying canceled orders in OPAC and Primo
      • Displaying format in Web OPAC
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 20
      2. contype:kba
      3. Dedicated-Direct
      4. Direct
      5. Local
      6. Prod:Aleph
      7. Type:Q&A
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved