instr (field, unistr('\2019'), 1 ) seems to work fine, but how do you
get from the dump output to this?
instr(field, chr(226) || chr(128) || chr(153) || chr(99), 1 ) also
works... a 'boundry' issue?
Does 99 signal some utf8 boundry.
On Jan 17, 8:07 am, oldyork90 <oldyor...@yahoo.com> wrote:
> 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
