Hi,
I have an unclean data stored in oracle DB. It contains many
undisplyable characters that reflect the wrong ASCII decimal. For
example the correct ASCII (' ') is 32 but when I do ASCII on this
invisible character I would get 0.
I need to create a stored procedure that will take fields from the DB.
Search them for the unwanted characters, clean it up and re-post the
cleaned data back in the DB.
I don't know how many or what type of invisible characters that are
stored. I know some of the unwanted characters are visible for viewing
when I do select in SQL but the uses can't see them in the forms.
Help please.
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Thu Dec 16 1999 - 14:43:44 CST
