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 <[EMAIL PROTECTED]>
To: mysql@lists.mysql.com
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/[EMAIL PROTECTED]


_________________________________________________________________
Are you using the latest version of MSN Messenger? Download MSN Messenger 7.5 today! http://messenger.msn.co.uk


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to