I am forced to use utf-8. Originally I used iso-8859-1, all was ok. the ms sql database stored and retrieved the data perfectly
Now The site uses unicode and and the data is stored with unicode and special characters are saved as 2 characters. This is unacceptable, it makes the site unusable
I have tried to use different collations in the tables to no avail.
When googling all I get is a confirmation f this issue between ms sql and unicode.