Unable to display certain punctuation characters from a memo field

[auylox]

Hello, I'm using
CR2016
Oracle 11.2
connection via ODBC

I'm trying to include a memo field in my report, but the following characters are being interpreted as question marks:

’ (alt+-146)
“ (alt+0147)
” (alt+0148)
– (alt+0150)
… (alt+0133)

I can replace the question marks using formulas. (ie. replace(pbs_text.text_long,"?","|~|")

When I query the database using Oracle SQL Developer, the punctuation is correct.

Thanks for any help!

 

[kray4660]

Should more like the font used to display the text. Just a thought.

 

[auylox]

I don't believe it is the font. I use the same font with those characters in other locations. If it were a font, I wouldn't expect the replace function to work.

 

[kray4660]

I have never had this issue so I am at a loss for an explanation.

 

[IanWaterman]

Not seen this either. Can you try another connection type. I never use ODBC for Oracle, Native Oracle is best. Though have used OLEDB occasionally.

Ian