phpMyAdmin¤ò»È¤Ã¤ÆMySQL¤Ë¥¢¥¯¥»¥¹¤·¤Æ¤¤¤ë¤Ê¤éµ¤ÉÕ¤«¥ó¥«¥à¥©¤À¤¬¡¢TeraTerm¤Ê¤É¤Î¥Æ¥¥¹¥È¤Ç¥¢¥¯¥»¥¹¤¹¤ë¤È¡¢·ë²Ì¤¬¡Ö???¡×¤È¤Ê¤êʸ»ú²½¤±¤·¤Æ¤¤¤ë¥³¥È¤¬¤¢¤ë¡£
phpMyAdmin¤Î¡Ö¥µ¡¼¥Ð¤Îʸ»ú¥»¥Ã¥È¡×¤ÏUTF-8¤Ë¤Ê¤Ã¤Æ¤ª¤ê¡¢
TeraTerm¤ÎÀßÄê¤ä¥Õ¥©¥ó¥È¤âUTF-8¤Ç¤¢¤ë¤Ë¤â¥«¥«¥ï¥é¥Å¤À¡£
MySQL¤Ç
show variables like '%character%' ;
¤È¤¹¤ë¤È¡¢¡Öcharacter_set_results¡×¤¬¡Ölatin1¡×¤Ë¤Ê¤Ã¤Æ¤¤¤ë¡£
# character_set_results¡§¥¯¥é¥¤¥¢¥ó¥È¤ØÁ÷¿®¤¹¤ëʸ»ú¥³¡¼¥É
¤Ê¥ó¤Ç¡¢
set character_set_results = utf8 ;
¤È¤·¤ÆUTF-8¤Ë¥·¥Æ¥ä¥ë¤È¡¢Àµ¾ï¤Ëɽ¼¨¤µ¤ì¤ë¡£
¥«¥¯¥Ë¥ó¤¹¤ë¤È¡¢°Ê²¼¤ÎÄ̤ꡢ¡Öcharacter_set_results¡×¤¬¡Öutf8¡×¤ËÊѹ¹¤µ¤ì¤¿¥³¥È¤¬Ê¬¤«¤ë¡£
¥À¥ì¤¬latin(¥é¥Æ¥ó)¡á¥¬¥¤¥¸¥ó¼Ù¡¢¥É¥¡¥ô¥©¡ª¡ª
¾¤Î¡Ölatin1¡×¤âÁ´Éô¡Öutf8¡×¤ËÀߥ·¥¿¥é/Àß³Ú¤ñ¡Á¥ó¤«¤Ï¥·¥é¥ó(SILANE)¤·¡¢utf8¤Èutf8mb4¤Î°ã¤¤¤Ï²¿¤«¤â¥·¥é¥ó(SILANE)¡£
set character_set_client = utf8 ;
set character_set_connection = utf8 ;
set character_set_database = utf8 ;
set character_set_server = utf8 ;
exit¤ÇMySQL¤òÈ´¤±¤Æ¡¢MySQL¤ÎºÆµ¯Æ°¡£
mysql.server restart
ºÆµ¯Æ°¤¹¤ë¤È¡¢¥à¥¡¥¿¡Ölatin1¡×¤ËÌá¥Ã¤Æ¤ë(ʸ»ú²½¤±Éü³è)¡¢¤³¤Î¥ô¥¡¥¯¥¡º¾²Ã¸º£÷£÷£÷£÷£÷
¤À¤¬¡¢phpMyAdmin¤Î¡Ö¤½¤Î¾¡äÊÑ¿ô¡×¤Ç¥«¥¯¥Ë¥ó¤¹¤ë¤È¡¢¡Ölatin1¡×¤Ï¸ºß¥·¥Ê¥¤æ«¡ª
¥â¡Á(MOW)¡¢¥ï¥¯¥§¤¬Ê¬¤«¤é¥Ê¤ð¥ç£÷£÷£÷£÷£÷£÷£÷£÷£÷£÷£÷£÷£÷£÷£÷
MySQL¤ÎÀßÄê¥Õ¥¡¥¤¥ë(my.cnf)¤òõ¤·½Ð¤·(ÊýË¡¤Ï¸å½Ò)¡¢
# Default Homebrew MySQL server config
[mysqld]
character-set-server=utf8 ¢«
[client]
default-character-set=utf8 ¢«
# Only allow connections from localhost
bind-address = 127.0.0.1
¤òÄɵ¤·¤ÆÊݸ¡¢MySQL¤òºÆµ¯Æ°¡£
MySQL¤Ç
show variables like '%character%' ;
¤ÇºÆ³Îǧ¡£
ºÆµ¯Æ°¤·¤Æ¤âutf8¤¬»Ä¤ê¡¢À®¸ù¡£
[PR] au PAY / au WALLET ¥«¡¼¥É ¾ðÊó
phpMyAdmin¤Î¡Ö¥µ¡¼¥Ð¤Îʸ»ú¥»¥Ã¥È¡×¤ÏUTF-8¤Ë¤Ê¤Ã¤Æ¤ª¤ê¡¢
TeraTerm¤ÎÀßÄê¤ä¥Õ¥©¥ó¥È¤âUTF-8¤Ç¤¢¤ë¤Ë¤â¥«¥«¥ï¥é¥Å¤À¡£
MySQL¤Ç
show variables like '%character%' ;
¤È¤¹¤ë¤È¡¢¡Öcharacter_set_results¡×¤¬¡Ölatin1¡×¤Ë¤Ê¤Ã¤Æ¤¤¤ë¡£
# character_set_results¡§¥¯¥é¥¤¥¢¥ó¥È¤ØÁ÷¿®¤¹¤ëʸ»ú¥³¡¼¥É
¤Ê¥ó¤Ç¡¢
set character_set_results = utf8 ;
¤È¤·¤ÆUTF-8¤Ë¥·¥Æ¥ä¥ë¤È¡¢Àµ¾ï¤Ëɽ¼¨¤µ¤ì¤ë¡£
¥«¥¯¥Ë¥ó¤¹¤ë¤È¡¢°Ê²¼¤ÎÄ̤ꡢ¡Öcharacter_set_results¡×¤¬¡Öutf8¡×¤ËÊѹ¹¤µ¤ì¤¿¥³¥È¤¬Ê¬¤«¤ë¡£
¥À¥ì¤¬latin(¥é¥Æ¥ó)¡á¥¬¥¤¥¸¥ó¼Ù¡¢¥É¥¡¥ô¥©¡ª¡ª
¾¤Î¡Ölatin1¡×¤âÁ´Éô¡Öutf8¡×¤ËÀߥ·¥¿¥é/Àß³Ú¤ñ¡Á¥ó¤«¤Ï¥·¥é¥ó(SILANE)¤·¡¢utf8¤Èutf8mb4¤Î°ã¤¤¤Ï²¿¤«¤â¥·¥é¥ó(SILANE)¡£
set character_set_client = utf8 ;
set character_set_connection = utf8 ;
set character_set_database = utf8 ;
set character_set_server = utf8 ;
exit¤ÇMySQL¤òÈ´¤±¤Æ¡¢MySQL¤ÎºÆµ¯Æ°¡£
mysql.server restart
ºÆµ¯Æ°¤¹¤ë¤È¡¢¥à¥¡¥¿¡Ölatin1¡×¤ËÌá¥Ã¤Æ¤ë(ʸ»ú²½¤±Éü³è)¡¢¤³¤Î¥ô¥¡¥¯¥¡º¾²Ã¸º£÷£÷£÷£÷£÷
¤À¤¬¡¢phpMyAdmin¤Î¡Ö¤½¤Î¾¡äÊÑ¿ô¡×¤Ç¥«¥¯¥Ë¥ó¤¹¤ë¤È¡¢¡Ölatin1¡×¤Ï¸ºß¥·¥Ê¥¤æ«¡ª
¥â¡Á(MOW)¡¢¥ï¥¯¥§¤¬Ê¬¤«¤é¥Ê¤ð¥ç£÷£÷£÷£÷£÷£÷£÷£÷£÷£÷£÷£÷£÷£÷£÷
MySQL¤ÎÀßÄê¥Õ¥¡¥¤¥ë(my.cnf)¤òõ¤·½Ð¤·(ÊýË¡¤Ï¸å½Ò)¡¢
# Default Homebrew MySQL server config
[mysqld]
character-set-server=utf8 ¢«
[client]
default-character-set=utf8 ¢«
# Only allow connections from localhost
bind-address = 127.0.0.1
¤òÄɵ¤·¤ÆÊݸ¡¢MySQL¤òºÆµ¯Æ°¡£
MySQL¤Ç
show variables like '%character%' ;
¤ÇºÆ³Îǧ¡£
ºÆµ¯Æ°¤·¤Æ¤âutf8¤¬»Ä¤ê¡¢À®¸ù¡£