Yesterday, when I ran into some rogue invisible characters in our database, I expected to have this problem solved in a few minutes. Lots of hours sunk into this. I expect an answer will take a minute or two for someone familiar with invisible characters to tap out the solution.
The problem showed up like this:
Looks like blank data
The problem is we have some customers with more than 3,000 cust_address records. None have more than 6 with visible characters in them. That means we have thousands of extra cust_address records. The problem they are not blank,k but flooded with invisible characters I don't know how to detect except by eye in screen displays.
This is how we store address data:
Basically, what I need to do is 
delete cust_address where <that field with weird data in it is invisible> and no visible characters present
update cust_address set<invisible character> = replace(address, <weird invisible char>, ' ')
I cannot figure out how to touch the weird invisible characters.
Any information you can provide will be appreciated immensely.
Thank you.