Set Server to latin 1 charset

[André Gasser]

hello!



can anyone tell me HOW i can force the server/database/connection/etc... to use the latin1 character set? I was looking for the configuration file parameters and tried to set some values:

set-variable = character_set_server=latin1

but as far as I can remember, that was the only one of the character_set_* values which the server accepted. when using a value like set-variable = character_set_connection=latin1 the server didn't start (had a system error).

I'm using a 4.1.11 mysql server using myisam engine.

thanks for any help
andré