Polish characters in data table replaced by numerical code
I added Polish to the list of languages for our internet shop. For data entry, I used pages generated with DataAssist. The charset is set to ISO-8859-1.
All Polish special characters were automatically converted into numerical code, and the display on the webpages converted back to Polish characters again. So far that's good.
However, when I export the database tables into Excel or OpenOffice, the numerical code is not converted back into legible Polish characters. I need this done though, because the translator has to correct the entries.
My attempt at a solution was to enter data as Polish characters (not numerical code). Export works fine then, but I have not been able to display the characters properly on the webpage. I then changed the coalition to utf8_general_ci both on the webpage and the data table, but still the Polish characters are not displayed correctly.
Are there any settings I can use to display Polish characters when they are not entered into the database as numerical code?
Or is there a way to export tables with numerical code, that will convert into characters?
Thank you for any help :)
Update: I learned that ISO 8859-1 does not include polish, but ISO 8859-2 does. I can't use two different charsets on the same page though, or can I? Would that mean there is no way around the numerical code?