Virtualmin/Webmin MySql charracter sets variables

1 post / 0 new
#1 Thu, 01/03/2008 - 13:17
resen

Virtualmin/Webmin MySql charracter sets variables

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