How can I change the characterset in mysql console?

[co.ador]

need to change the

 

Server Characterset, Db Characterset And Client Characterset

From latin1 to utf8

 

Does any body has an idea on how to do it on mysql console?

 

Thank you

[corbin]

To set the connection to use UTF8, you can simply do a query like:

 

 

SET NAMES utf8;

 

 

If you want to set UTF8 as the default, you'll have to do some tinkering in my.conf (or my.ini or whatever it's called).  I'm sure you can find the variable name by googling.

 

 

As for setting a table character set:

 

CREATE TABLE sometable (

    field1 varchar(255) CHARSET=UTF8

);

 

(You might have to do "CHARACTER SET UTF8" instead of CHARSET....)

 

 

Or:

 

CREATE TABLE sometable (

    field1 varchar(255)

) CHARSET=UTF8;

 

As for the default on that, I'm sure it's another my.cnf option.