Here is utf8 text and it's dump() >From a varchar2 .. dump(field, 10)
C r i t è r e s d’ i 43, 72, 69, 74, c3,a8, 72, 65, 73,20, 64, e2, 80, 99, 69 HEX 67,114,105,116,195,168,114,101,115,32,100,226,128,153,105 DEC inst(text, chr(226)||chr(128)||chr(153), 1) finds nothing This is what I'm trying to find via a code UCS-4: 00002019 RIGHT SINGLE QUOTATION MARK Glyph: ’ UTF-8: E2 80 99 GB-18030: A1AF ASCII 8C: 00869 ASCII 92: 01250 01251 01252 01253 01254 01255 01256 01257 01258 ASCII A2: ISO-8859-7 ASCII EF: 00775 ASCII FF: ISO-8859-13 EBCDIC 72: 01005 EBCDIC DE: 00875 EBCDIC DF: 01156 I need to find this 'character' and replace it with a standard quote. 10g -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
