I have quite a strange problem. I had installed UCCASS on MYSQL4, together with Drupal.
In the survey.ini.php I set the encoding to utf8 and the database was the same.
One day my administrator upgraded database to MYSQL5, which changes old utf into latin (Swedish version
1. in survey.ini.php encoding is utf
2. database and tables are set to utf
3. data in table text_results are encoded to utf
3. when I enter the database through phpmyadmin everything looks cool for the text results
4. other tables in the db have polish chars, look terrible in phpmyadmin but are displayed in the browser in a good way when I enter it through mywebpage
alas!
when I want to display text answers (only they are not working), in the browser there are not Polish chars.
The most puzzling thing is that when I completed another survey with polish chars in text field, they are displayed in a good way on the webpage but are crooked in phpmy admin.
I have a lot of important stuff overther and I would like to save it somehow.
So which part of the code is responsible for encoding both entered and displayed data? I am not good at php and actually I feel lost. Can anyone help?
Albert Hupa