mysql

■■キャラセット
[client]
default-character-set = utf8
[mysqld]
character_set_server = utf8
[mysql]
default-character-set = utf8
[mysqldump]
default-character-set = utf8

■■mysqli
■接続
$mysqli = new mysqli("localhost", "id", "pass", "db");
$mysqli->set_charset("sjis"); // クライアントの文字セット
■キャラセット確認
echo $mysqli->character_set_name();
■select
$query = "select * from t1";
$stmt = $mysqli->prepare($query);
$stmt->execute();
$stmt->bind_result($id,$name,$text,$created);
while ($stmt->fetch()) {
echo $name." ".$text."
";
}
■insert
$query = "insert into t1 set name='',text=''";
$mysqli->query($query);
■close
$mysqli->close();