I want to start of by saying that I'm very new to SQL and PHP, I've done a bit of research for this but I usually manage the network so some concepts are very new for me!
Now here's my situation:
We've purchased a program (from a schoolboard, not an actual company so no support is available) that works off a web page. It uses php with a sql DB.
We were not told the requirements so I made the setup with Windows server 2012, IIS and sql 2012(free edition), but the programmer built this on server 2008R2, apache and mysql and this is creating a few issues.
His PHP pages are encoded with ANSI but once installed it, I needed to switch the PHP pages to UTF-8 since we use french characters ( é, è, à, ç, etc...), this solved the web page issue but for the DB, since he uses MySQL, is collation is Latin1 and mine is French_CI_AS so all french characters ( é, è, à, ç, etc...) in the DB comes out wrong (Ã©,Ã, Ã§, Ã©,lÃ¨) and same thing when we export the data to word/excel.
Now I've managed to create a query to change existing errors but want to fix this permanently.
Do I simply need to change the collation on the SQL DB or should I think about creating a new server with the recommended settings ( which seems more complicated as I know nothing about apache/php/MySQL)