---
title: MySQLでデフォルト文字コードをUTF-8にする
tags: []
categories: ["Middleware", "RDBMS", "MySQL"]
date: 2010-12-20T01:19:23Z
updated: 2010-12-20T01:19:23Z
---

毎回ぐぐってるのでメモ。

my.cnfに以下の設定をして再起動

    [mysql]
    default-character-set=utf8
    
    [mysqld]
    default-character-set=utf8
    character_set_server=utf8
    skip-character-set-client-handshake

以下のようになっていればおｋ。

    mysql> show variables like "char%";
    +--------------------------+----------------------------+
    | Variable_name            | Value                      |
    +--------------------------+----------------------------+
    | character_set_client     | utf8                       |
    | character_set_connection | utf8                       |
    | character_set_database   | utf8                       |
    | character_set_filesystem | binary                     |
    | character_set_results    | utf8                       |
    | character_set_server     | utf8                       |
    | character_set_system     | utf8                       |
    | character_sets_dir       | /usr/share/mysql/charsets/ |
    +--------------------------+----------------------------+
    8 rows in set (0.00 sec)