Re: It's still going on
Had a similar problem with a social services application I used to support. Database was Oracle, ASCII (I think) character set. Users would copy and paste from various other applications, Word, Excel, whatever. Application would happily swallow whatever was copy pasted in, and then throw an unhandled error when you tried to retrieve that particular form because it contained what ASCII considered as control characters. Took a while to work out what was going on but earned me a lot of brownie points when I twigged and could fix the offending form generally within 30 minutes of being aware of the problem. Honestly, it was frequently a 5 minute job but never let the end users know it's easy. Supplier took 24 hours to fix such issues, their long term fix was to suggest we upgraded, at considerable expense, to their latest and greatest rewrite of the application. We did consider that, but it went nowhere, partly because their 'expert' didn't understand that their application when running on a Solaris box, pointing at a database on another Solaris box, didn't need, and in fact probably couldn't, map to the C:\ drive.