I have a CQ database using ISO Latin 1 code page and I get a lot of complains from people who try to cut/paste emails into one or two multiline text fields. I looked at switching the CQ schema and backend Oracle database to UTF8 but this is not supported by Rational for existing schemas/databases.
So my other thought was to make add some form of validation hook code which would sanitize/convert the pasted data to ISO Latin 1 code page. How have others worked around this issue? Does anyone have hook code to do the sanitization/conversion?