From: Reindl Harald
Date: November 18 2011 10:08am
Subject: Re: how do I make utf8 the default encoding for my MySQL installation
List-Archive: http://lists.mysql.com/mysql/226322
Message-Id: <4EC62EA3.607@thelounge.net>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature";
 boundary="------------enig42D8FA3C88EA7ADF172F09FF"

--------------enig42D8FA3C88EA7ADF172F09FF
Content-Type: text/plain; charset=ISO-2022-JP
Content-Transfer-Encoding: quoted-printable



Am 18.11.2011 04:31, schrieb Martin Mueller:
> [mysqld]
> init_connect=3D=1B$B!G=1B(BSET collation_connection =3D utf8_general_ci=
=1B$B!G=1B(B
> init_connect=3D=1B$B!G=1B(BSET NAMES utf8=1B$B!l=1B(B
> default-character-set=3Dutf8
> character-set-server=3Dutf8
> collation-server=3Dutf8_general_ci
> skip-character-set-client-handshake

> On a Mac with MySQL 5.5.17 this produces the error
>  [ERROR] /usr/local/mysql/bin/mysqld: unknown variable
> 'default-character-set=3Dutf8'


character-set-server =3D utf8
collation-server     =3D utf8_general_ci

and done

"default-character-set" is an older option, was long time deprecated
and removed - you should NEVER paste options in your configs only
because some random guy say they do what you want before you
read the manuals what they are doing



--------------enig42D8FA3C88EA7ADF172F09FF
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAk7GLqMACgkQhmBjz394AnmyAwCfdXU4bFenRF1N4ufx4Q61yrb2
zGkAn2FuNWJ2LkJu9mIihv8jbacK4/5K
=aC/L
-----END PGP SIGNATURE-----

--------------enig42D8FA3C88EA7ADF172F09FF--