Hi,

I want to set the default character set to latin1_swedish_ci. I've changed my my.ini file to:

[mysqld]
basedir=C:/mysql
datadir=C:/mysql/data

default-table-type=innodb

character_set_client = latin1_swedish_ci
character_set_connection = latin1_swedish_ci
character_set_database = latin1_swedish_ci
character_set_results = latin1_swedish_ci
character_set_server = latin1_swedish_ci
character_set_system = latin1_swedish_ci
collation_connection = latin1_swedish_ci
collation_database = latin1_swedish_ci
collation_server = latin1_swedish_ci

[WinMySQLadmin]
Server=C:/mysql/bin/mysqld-nt.exe
user=XXX
password=XXX

But now MySQL doesn't start any more.

I'm using MySQL 4.1.7 on Windows 2000....

Thanks for your help,
Markus