We have to strip out MS office special characters such as em hyphens, MS Office specific single and double quotation marks, etc.... When saving user's comments to our oracle table.
When reviewing our code, the replace functions show red square boxes instead of the actual values we set in our sql code files. Any way to get our schema browser preview window and editor to display these types of special characters correctly?
Thanks in advance for your assistance.....
What is your Editor font configured to? See the Editor | Font and Styling page in Toad Options. Choose the Default style and check the font.
Squares usually indicate the character is known, but can't be represented. Typically a font issue. If it were a problem with Unicode characters being lost due to character set incompatibilities then a question mark will be used in place of these Unicode characters. The Consolas font is default and should be able to display these characters. I just tried with double quotes using the "smart quote" characters and was able to see them in the Schema Browser for a compiled procedure.
