Polish characters in data table replaced by numerical code

Hi,

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?

Use Dynamic Connections for the database connection.

In Dynamic Connections, you can select the character set to be used by the connection, set it to the UTF 8 character set.

also use the UTF 8 character set on your pages.

Jason, that worked like a charm. Thank you sooo much.

I changed the data entry pages as well, and just by updating each product, the numerical code is replaced. That is better than doing the data entry all over again.

Thanks :)