First, ensure your encoding is set to the same across your two systems and is correct for your data. Then if it's the same, you have to clean your data. There really isn't any way around that. However, the COMPRESS() function allows you remove invisible white characters. You could apply it to all your character strings and remove any invisible characters but that won't deal with the 'scrambled code', whatever that means.
... View more