Unable to display certain punctuation characters from a memo field

auylox · Sep 21, 2018

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 · Sep 21, 2018

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

auylox · Sep 21, 2018

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 · Sep 25, 2018

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

IanWaterman · Sep 26, 2018

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

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Unable to display certain punctuation characters from a memo field

auylox

Technical User

kray4660

MIS

auylox

Technical User

kray4660

MIS

IanWaterman

Programmer

Similar threads

Part and Inventory Search

Sponsor