Hi
I'm having a problem when doing LIKE '' queries in mySQL
These are my variables
- character_set_client utf8
- character_set_connection utf8
- character_set_database latin1
- character_set_filesystem binary
- character_set_results utf8
- character_set_server latin1
- character_set_system utf8
- character_sets_dir C:\xampp\mysql\share\charsets\
1) How could I change db collation? And tables? I have:
- Some tables as MyISAM with latin1_swedish_ci
- Some tables as InnoDB with utf8_general_ci
I guess I should convert every table InnoDB with utf8_general_ci
2) I guess DB is set to latin1_swedish_ci so I should change this also. Doing the process from answer 1) will avoid the Illegal mix of collations error in mySql right? Without changing any line of code...?
Thanks