Re: Help changing PERMANENTLY the charset_connection, reults and client variables

[Renich Bon Ciric]

Ok, this is what I did.

Edit my.cnf (located at etc... at least in fedora core 4)

add the following line to [mysqld] AND [mysql] sections in the cnf file.

default-character-set=utf8

The whole my.cnf file should look like this:

[mysqld]
default-character-set=utf8

[mysql]
default-charater-set=utf8

Obviously, there is some other data... but i don't wanna type it!

Well, if you check your variables with a:

$>mysql -u root -p
$>password:*******
mysql> show variables like '%char%'

you will see that everything changed to "utf-8"

My encoding problems have not ended with this, though... in fact, i have a lot of problems with table names and data with foreign characters...