Re: utf8 character show as ???

[Shuichi Tamagawa]

Avi Laviad wrote:
> everytime that i do :
> SET character_set_client = utf8
> SET character_set_connection = utf8
> SET character_set_results = utf8;
>
> it seems to change the values (i do show variables
> to check it out),
> but after i logout and login again it returns to
> be latin1...
> why is that?

The variables set by SET command are effective within the connection.
If you don't want to do this everytime, you can add default-character-set = utf8 in [mysql] section of my.cnf file (if you are using mysql client program)

By the way, to change these three variables, you can simply execute one statement :)

SET NAMES utf8;