とみたです。

On Thu, 7 Jul 2005 19:01:28 +0900
荒木　満 <araki@xxxxxxxxxx> wrote:

> set names / set character set
> についてですが、MySQLのサイトを見ると
	〜中略〜
> とありますので
> set names < set character set
> と解釈できるように感じるのですが、どうなのでしょう？

mysql.com の日本語訳は古いです。英語のマニュアルを見ると、
http://dev.mysql.com/doc/mysql/en/charset-connection.html

  A SET NAMES 'x' statement is equivalent to these three statements:
  
  mysql> SET character_set_client = x;
  mysql> SET character_set_results = x;
  mysql> SET character_set_connection = x;
  
  Setting character_set_connection to x also sets collation_connection
  to the default collation for x.
  
  SET CHARACTER SET is similar but sets the connection character set
  and collation to be those of the default database. A SET CHARACTER
  SET x statement is equivalent to these three statements:
  
  mysql> SET character_set_client = x;
  mysql> SET character_set_results = x;
  mysql> SET collation_connection = @@collation_database;

となってます。character_set_connection は
http://dev.mysql.com/doc/mysql/en/server-system-variables.html

  The character set used for literals that do not have a character set
  introducer and for number-to-string conversion.

ということなので、SET NAMES を使用した方がいいですね。

-- 
とみたまさひろ <tommy@xxxxxxxxxx>
日本MySQLユーザ会 http://www.mysql.gr.jp