I am a new Apache Friends user but I have been playing with XAMPP for a while.
OK, so this is my question: I have been reading about encoding in mysql. And I have a problem. I am trying to set all my encoding to UTF8. I saw that editing "my.cnf" would achieve that. The thing is I cannot manage to change character_set_client, character_set_results and character_set_connection, the parameters managed from SET NAMES order.
This is what I added under [sqld] in my.cnf:
- Code: Select all
init_connect='SET NAMES utf8'
skip-character-set-client-handshake
I have discovered two things:
First, there is a file called "databaseinterface.class.php" which is in charge of setting the initial parameters. If I edit this file, I manage to do it.
Second, UTF8 is automatically converted into UTF8MB4. I read that this is just an improvement of UTF8, so that's fine for me.
So, bottom line: can I change client, results and connection encoding from my.cnf or do I need to edit "databaseinterface.class.php"?
Thanks a lot!