Database Character Set latin1 and Collation latin1_swedish_ci
I am making a copy of my database to use as a testing server.
1) Do you prefer to have your testing server local or actually on the server
2) My current settings are
Database Character Set latin1
and Collation latin1_swedish_ci
Everything is working so I assume I should keep it the same but I am really attempting to ensure I understand the how's and why's or at least get a confirmation that my environment is set up optimally.