good morning listmembers

i temporarily want to change mysql's characterset.

the statement mysql> show variables like 'character_set'; shows me the result:

character_set | latin1


ok. the statement mysql> show variables like 'character_sets'; shows me the result:

character_sets | latin1 big5 czech euc_kr gb2312 gbk latin1_de sjis tis620 ujis dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5


which are the possible charactersets as i understand it. To change the current characterset to german1 for example i use the statement:


mysql> set character set german1;
ERROR 1115: Unknown character set: 'german1'


hm ... ??? whats going wrong? Why will i get an error message? Can someone explain the write way to change the characterset temporarily?

thanks :-)