Up until recently all our comments text in a table has been encoded in ISO-8859-1 format.
Due to a change in an application, some comments are now in the database encoded into UTF-8 format.
I thought this wouldn't be a problem, as our database can cope with UTF-8 encoding and so can my new module in the application (written in Java). However, there is some legacy code that I don't understand, to do with downloading excel files, that can't cope with these UTF-8 comments.
i.e. the user downloads the excel file and sees the comment as Flew%2Bnorth%2Bover%2BGSK%2Bfactory%2Bmid%2Bmorning - it is not decoded.
Is there a way of changing all the UTF-8 comments in the database back to ISO-8859-1 format ? I found mention of a CONVERT command, but couldn't get it to work.
thanks for your help!