MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:July 27 2004 12:41pm
Subject:Re: set character set on MySQL 4.0.18
View as plain text  
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
Thread
set character set on MySQL 4.0.18Chris Wright27 Jul
  • Re: set character set on MySQL 4.0.18Paul DuBois27 Jul