I have an oracle 12c database with UTF8 character set running on Red Hat Linux 5.8.
I need to update a erroneous character representation in some database records for phono character defined in this link.
The character is stored with other regular ascii text in a VARCHA2 column.
I use SQL*plus on windows 7 desktop or I also have TOAD and Sql Developer
I need to replace those character with correct uff8 encoding for phono character.
The string to replace is "򴒧" in VArChar2 field.
Would you a replace statement (source string,target string) with a target of "U+2117" or the bytes 0xE2 0x84 0x97?