MySQL 4.1 differs from its predecessor MySQL 4.0 in the way it processes encoding and if you want it to work correctly you may need to alter some settings.

To do this:

1. set your default collation in db admin for the database (you can omit this step when using windows-1250 encoding). Log in to db admin and in the left menu click on the name of your database, then click Operations and at the very bottom there is the collation menu, where you can choose your encoding.

2. when importing a database you have to choose a correct encoding of the imported file:

cp1250  = windows-1250
iso-8859-2 = latin2

3. the scripts you use to connect to your database should determine the encoding that will be used for the communication with the database.

Windows-1250 (cp 1250) is the default setting. To use another encoding, you can use these queries, which should be run immediately after you have logged in to your database:

mysql_query(""SET character_set_results=kodovanie"");
mysql_query(""SET character_set_connection=kodovanie);
mysql_query(""SET character_set_client=kodovanie"");