[MYSQL 4.0.x] Encoding change problem

[Wiesiek]

Hi.

I have a server with mysql 4.0.x (debian version).

Now I want to change encoding with mysql.

character_set is set to latin1
character_sets is set to latin1 big5 cp1251 cp1257 croat czech danish dec8 ...

In database I have a many texts with 3 languages. If I try UPPER this text, with latin1 some "lang specyfic letters" are not upper ;(

I try this:
SET @character_set_results = "latin2";
but this failed:

#1193 - Unknown system variable 'character_set'

SET GLOBAL character_set_results = "latin2";
SET @@character_set_results ="latin2";
SET GLOBAL character_set_results "latin2";
SET @@character_set_results "latin2";

produce the same error message.

I readed documentation but all faild ;/

PS
Yes.. I now it can be changed in config file, but I don't have administrator rights.

--
I greet
Wieslaw