At 12:34 +0100 7/27/04, Chris Wright wrote:
>I'm having trouble with character set changes on 4.0.18.
>
>I have a database that contains text in multiple languages and I need to
>be able to select the character set on the fly.
>
>For some reason "SET CHARACTER SET x" always returns "Unknown character
>set: 'x'". The only exception to this is "SET CHARACTER SET DEFAULT".
>
>I know the character sets I'm trying are installed, even trying to set
>the default by name does not appear to work.
>
>Any suggestions?
What you're trying to do is not supported until 4.1.1:
http://dev.mysql.com/doc/mysql/en/SET_OPTION.html
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
