Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Voyager

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Voyager
    3. Knowledge Articles
    4. Voyager Prepackaged Access Reports SQL and Microsoft Office "smart quotes"

    Voyager Prepackaged Access Reports SQL and Microsoft Office "smart quotes"

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Description
    2. Resolution
    3. Additional Information
    • Product: Voyager
    • Relevant for Installation Type: Multi-Tenant Direct, Dedicated-Direct, Local, TotalCare

     

    Description

    Microsoft Office applications such as Word and Outlook automatically change straight quotation marks ( ' or " ) to curly quotiation marks (also known as "smart quotes" or typographer's quotes).  If introduced into SQL code used in Access or sqlplus, smart quotes will break the code.

    Resolution

    If you are using SQL code that is passed through a Microsoft application, be aware of this potential problem.  

    If you move SQL code into Microsoft Word or Outlook, you can turn smart quotes off.  Use the application's internal Help function for instructions.

    Additional Information

    The following provides an example of "smart quotes" as auto-corrected by Microsoft Word, followed by an example of straight quotes:

     

    smartquotes.jpg

    .

    For some additional useful information on smart and straight quotes, see: https://practicaltypography.com/straight-and-curly-quotes.html 

     


    • Article last edited: 20-Nov-2019
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Voyager PrePackaged Access Reports "file may be corrupt" error
      • Voyager Reporter produces "Failure Recovery Run" error and "The previous execution of the Voyager Reporter FAILED!" error when running circulation notices
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Voyager
    2. Tags
      This page has no tags.
    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