Invalid code in the column and DUMP function
Hi all,
My DB is 11.1 and Character set is UTF8.
After ETL, I find some invalid characters appear in my tables, one of which is '�'. Since they are history data, I can't find the source data for them.
The only choice for me now seems to remove all of them for downstream systems. After issuing select dump(column,10) from mytable, I find that '�' is represented by
239，191，189.
So I guess whether I can dump the data, remove the bad string and then umdump the contents to get the good string. In a word, is there an inverse function for dump function?
My DB is 11.1 and Character set is UTF8.
After ETL, I find some invalid characters appear in my tables, one of which is '�'. Since they are history data, I can't find the source data for them.
The only choice for me now seems to remove all of them for downstream systems. After issuing select dump(column,10) from mytable, I find that '�' is represented by
239，191，189.
So I guess whether I can dump the data, remove the bad string and then umdump the contents to get the good string. In a word, is there an inverse function for dump function?
0