Mam problem z przeniesieniem bazy danych..
Na 2 serwerze po imporcie wykrzaczają się polskie znaki..
Sprawdziłem kodowania na obu serwerach
Kod
SHOW VARIABLES LIKE "character_set%";
na 1 zwraca:
Kod
Variable_name Value
character_set_client utf8
character_set_connection utf8
character_set_database latin2
character_set_filesystem binary
character_set_results utf8
character_set_server latin2
character_set_system utf8
character_set_client utf8
character_set_connection utf8
character_set_database latin2
character_set_filesystem binary
character_set_results utf8
character_set_server latin2
character_set_system utf8
na drugim:
Kod
Variable_name Value
character_set_client utf8
character_set_connection utf8
character_set_database utf8
character_set_filesystem binary
character_set_results utf8
character_set_server utf8
character_set_system utf8
character_set_client utf8
character_set_connection utf8
character_set_database utf8
character_set_filesystem binary
character_set_results utf8
character_set_server utf8
character_set_system utf8
czyli jest róznica w
Kod
character_set_server utf8
Jak przenieść baze tak aby nie bylo krzaków na drugim serw??