Reconfigure my MySQL server for utf8 support
Dave M G
martin at autotelic.com
Wed Feb 15 02:33:49 UTC 2006
Ubuntu Users,
I installed MySQL on my Ubuntu system via Synaptic. In other words,
I used a GUI point and click interface, and saw nothing of configuration
options.
Now, I find that what I want to do is change all the system
variables related to encoding and collation to use utf8.
I have gained some advice from the MySQL mailing list, and the manual:
http://dev.mysql.com/doc/refman/4.1/en/charset-server.html
Apparently, one can reconfigure MySQL using ./configure or something
like that to rebuild (?) the server so that it has utf8 as the default
encoding.
But, my stumbling block is that the advice I've got on the MySQL
mailing list and in the manual assumes that one is comiling from source
and not simply obtaining from a repository. There is also an assumption
of knowledge about what is being configured and where to run the commands.
I am not so knowledgeable. I'm a newbie who is in over my head.
Since I got my MySQL through Synaptic and the Ubuntu repositories, I
have no idea where or how to run configuration commands. All I know is
that I want *all* the following variables to be set *permanently* to utf-8.
Can someone give me a beginners rundown on how to do this?
These are the relevant variables:
Variable Session value Global value
character set client utf8 latin1
character set connection utf8 latin1
character set database latin1 latin1
character set results utf8 latin1
character set server latin1 latin1
character set system utf8 utf8
collation connection utf8_general_ci latin1_swedish_ci
collation database latin1_swedish_ci latin1_swedish_ci
collation server latin1_swedish_ci latin1_swedish_ci
Any advice would be much appreciated.
Thank you.
--
Dave M G
More information about the ubuntu-users
mailing list