Is there an Oracle function that can recognize if a character is readable or not?
I would like to search a specific column for garbled characters. I know that this can typically be done with a regular expression. However, my database contains Japanese characters, so it is not just a simple matter of an [A-Z][0-9]
pattern.
Best Answer
I think the answer given the specifics is "no there is not." I would think, however, in Oracle you could use a regular expression perhaps to find fields with characters not in a specific set. See http://docs.oracle.com/cd/B19306_01/appdev.102/b14251/adfns_regexp.htm
I don't know how regex usage works with indexes on Oracle however.