hi friends !
i have some trouble with mysql characters sets, i have no idea why it is so…
can you explain it ? i need all in cp1251
in Virtualmin/Webmin (webmin >> services >> mysql server)
character_set_client latin1
character_set_connection latin1
character_set_database cp1251
character_set_filesystem binary
character_set_results latin1
character_set_server cp1251
character_set_system utf8
character_sets_dir /usr/share/mysql/charsets/
collation_connection latin1_swedish_ci
collation_database cp1251_general_ci
collation_server cp1251_general_ci
in mysql -u root -p
character_set_client cp1251
character_set_connection cp1251
character_set_database cp1251
character_set_filesystem binary
character_set_results cp1251
character_set_server cp1251
character_set_system utf8
character_sets_dir /usr/share/mysql/charsets/
collation_connection cp1251_general_ci
collation_database cp1251_general_ci
collation_server cp1251_general_ci
init_connect | SET CHARACTER SET cp1251
other situation 
i have a touble with displaying some of my php scripts
all letters look like ??? ??? ???
also in php script i have (for example)
$conn_mysql=mysql_connect($host,$user_db,$pass);
mysql_select_db($db);
$query21="SET CHARACTER SET cp1251";
mysql_db_query("$db","$query21"); echo mysql_error();
thanks for advice