MS Word Smart Quotes Saved Return as Question Marks (?Hello World? or ¿Hello World¿)
Last updated on AUGUST 21, 2017
Applies to:Oracle Forms - Version 10.1.2.3.0 and later
Information in this document applies to any platform.
The above figure shows an example of what Smart Quote are and used for demonstration purpose only.
Data in the DB was saved by copying MS Word Text, Pasting it into Forms, and saving it. Some of the data from MS Word contains MS "Smart Quotes" which are also called "Curly Quotes" or "Typographer's Quotes"
When copied into the text field the quotes appear normal. However, when the data is saved and re-queried the quotes are not returned accurately. For example:
- If double "Smart Quotes" are used then “Hello World” displays as ¿Hello World¿
- If single "Smart Quotes" are used then ‘Hello World’ becomes `world¿
- If the data is examined in the data base using commands from <Note 13854.1> "Dump SQL Command for NLS Debugging" one can see the following:
ASCII for the double "Smart quote" was saved as 191 for both the leading and trailing quote. It should be 147 for leading and 148 for trailing.
One can see similar problems for the saved single "Smart Quote". The leading and trailing ASCII representation should be 145 and 146 respectively but it is also saved incorrectly.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms