How to store Emoji Character in MySQL Database


1 . config..php

define('G5_DB_CHARSET', 'utf8');
-->
define('G5_DB_CHARSET', 'utf8mb4');

2. /adm/sql_write.sql

) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
->
) ENGINE=MyISAM  DEFAULT CHARSET=utf8mb4;

3. change all table to utf8-mb4

use this.. :)

<?php
include_once('./_common.php');

echo "<xmp>";

$sql="ALTER DATABASE ".G5_MYSQL_DB." CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci";
sql_query($sql,true);
echo $sql,"\n";

$sql = "SHOW TABLES FROM ".G5_MYSQL_DB;
echo $sql,"\n";

$rst = sql_query($sql);
while ($row = sql_fetch_array($rst)) {
$table_name=$row['Tables_in_'.G5_MYSQL_DB];
//var_dump($row['Tables_in_u_daclick']);
    $sql2="ALTER TABLE `{$table_name}` DEFAULT CHARSET=utf8mb4 COLLATE utf8mb4_general_ci";
sql_query($sql2);
echo $sql2,"\n";

    $sql2="ALTER TABLE `{$table_name}` CONVERT TO CHARACTER SET utf8mb4";
sql_query($sql2);
echo $sql2,"\n";
}


작성 로빈아빠