What I understand you are saying is that out of 20,000 spaces in some table you get 19,999 and one @.
Need schema and representative info to help further.
Have you tested this in Windows?
Have you confirmed that there is really no @ in your data?
WHERE COLUMNNAME LIKE ‘%@%’