Hi,
The precise instructions are here:
http://dev.mysql.com/doc/refman/5.0/en/charset-syntax.html
You can start your server specifying the character set
(http://dev.mysql.com/doc/refman/5.0/en/charset-server.html), and alter the
databases (http://dev.mysql.com/doc/refman/5.0/en/charset-database.html),
but if it is your local home installation you could also recompile mysql
specifying utf8 when you run configure. That's the option I chose for my
personal home installation and I updated the server version at the same time
:-)
hth,
melanie
>From: Dave M G <martin@stripped>
>To: mysql@stripped
>Subject: Re: Unable to duplicate a database at home, possible encoding
>problem
>Date: Wed, 15 Feb 2006 02:54:00 +0900
>
>
>>detailed info here:
>>http://dev.mysql.com/doc/refman/5.0/en/charset-connection.html
>
>
>Thank you for that link. I think this is the heart of the issue.
>
>Following the advice on the web page, I ran these commands:
>SET NAMES utf8;
>SET CHARACTER_SET utf8;
>
>But I can check my MySQL system variables in phpMyAdmin, and here's what it
>says:
>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
>
>What I want to do is change *all* of these to utf8. That's the only
>encoding I ever work in, and I want to make my system as consistent as
>possible.
>
>What commands do I run to permanently fix all of these collation and
>character set variables to utf8?
>
>--
>Dave M G
>
>--
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe:
>http://lists.mysql.com/mysql?unsub=1
>
_________________________________________________________________
Are you using the latest version of MSN Messenger? Download MSN Messenger
7.5 today! http://messenger.msn.co.uk
