MS Word smart quotes don't paste the same into Forms 10g as Forms 6i
Hi all,
I have users who write text in Microsoft Word and then cut-and-paste it into Oracle Forms.
After some prodding by the developers, the users have switched to using the 10G version of their application instead of the 6i version.
As a background you should know that Microsoft Word uses Smart Quotes by default, which you can turn off. Smart Quotes are different ascii characters than the ascii 39 single quote and ascii 34 double quote.
When the users cut-and-paste the Microsoft Word text into the Forms 10G field, the single apostrophe smart quote does not convert to ascii 39. I wouldn't be surprised about this except that in Forms 6i the form does convert the single apostrophe smart quote into ascii 39.
So if the users use the 6i Form they can cut-and-paste and the form/database has the character as ascii 39. If the users paste into Forms 10G then the database shows the character as ascii 191 (hex 0xBF), which is an inverted question mark.
Does anyone know of any settings in Forms 10g to revert back to 6i functionality for this?
Thanks much,
Troy