{"id":1720,"date":"2008-06-23T04:16:56","date_gmt":"2008-06-23T04:16:56","guid":{"rendered":"http:\/\/dev.jblove.net\/?p=1720"},"modified":"2008-06-23T04:16:56","modified_gmt":"2008-06-23T04:16:56","slug":"mysql-utf-8%eb%a1%9c-%ec%9d%b4%ec%a0%84%ed%95%98%ea%b8%b0","status":"publish","type":"post","link":"https:\/\/jblove.net\/?p=1720","title":{"rendered":"mysql UTF-8\ub85c \uc774\uc804\ud558\uae30"},"content":{"rendered":"

[\uc11c\ubc84\uc6b4\uc601] utf-8 \ub85c \uc774\uc804\ud558\uae30.[\uc218\uc815]  
 
 \uae00\uc4f4\uc774   \uc1a1\ud6a8\uc9c4  \ub0a0 \uc9dc 07-12-17 11:15  \uc870 \ud68c 613
 
 
utf-8 \ub85c \uc774\uc804\ud558\uae30. <\/P>
\n

1. MySQL <\/P>
\n

– euckr \uc2a4\ud0a4\ub9c8 \ubc31\uc5c5
mysqldump –all-databases –no-data –set-charset=euckr -p &gt; backup.scheme.sql <\/P>
\n

– euckr \uc790\ub8cc \ubc31\uc5c5
mysqldump –all-databases –no-create-db –set-charset=euckr -p &gt; backup.data.sql <\/P>
\n

\uc6ec\ub9cc\ud558\uba74 \uc0ac\uc6a9\uc790\uacc4\uc815 \uc815\ubcf4\ub294 \uc554\ud638\uae4c\uc9c0 \ud655\uc2e4\ud558\uac8c \uc54c\uace0\uc788\uc790.
GRANT ALL \ucffc\ub9ac\ubb38\uc744 \uc9c1\uc811 \uc791\uc131\ud558\uc5ec \uac00\uc9c0\uace0 \uc788\uc790. <\/P>
\n

– UTF-8 \uc744 \uc81c\ub300\ub85c \uc9c0\uc6d0\ud558\uae30 \uc704\ud574 \ubc84\uc804\uc744 5.x \ub85c \uc62c\ub9b0\ub2e4.
(varchar(1) \uc740 1byte \uac00 \uc544\ub2cc \ud55c\uae00\uc790\ub97c \uc758\ubbf8\ud558\uac8c \ub41c\ub2e4.
set names \ub9cc\uc73c\ub85c \ud074\ub77c\uc774\uc5b8\ud2b8\uc758 \uce90\ub9ad\ud130\uc14b\uc744 \ub9de\ucd9c \uc218 \uc788\ub2e4.)
= backup.scheme.sql =
\ud14c\uc774\ube14 \uc911 BLOB \ud615\uc2dd\uc774\ub098 BINARY \uc18d\uc131 \ud544\ub4dc\uc5d0 \ubb38\uc790\uc5f4\uc774 \ub4e4\uc5b4\uac00\ub294 \uacf3\uc774 \uc788\ub2e4\uba74,
TEXT \ud615\uc2dd\uc73c\ub85c \ubc14\uafb8\uac70\ub098 BINARY \uc18d\uc131\uc744 \uc5c6\uc564\ub2e4.
DEFAULT \\’0\\’ \uac19\uc740 \uc798\ubabb\ub41c \ub530\uc634\ud45c\ub97c \uace0\uce5c\ub2e4.
TYPE=MyISAM \uac19\uc740\uac74 ENGINE=MyISAM \uc73c\ub85c \uc218\uc815\ud55c\ub2e4.
\ub9e8 \uc704\ucabd\uc758 SET NAMES euckr \uc744 \uc81c\uc678\ud55c \ubaa8\ub4e0 CHARACTER SET \uc758 euckr \uc744 utf8 \ub85c \uc218\uc815\ud55c\ub2e4. <\/P>
\n

cat backup.scheme.sql | mysql -p <\/P>
\n

= backup.data.sql =
head backup.data.sql # \ub9e8 \uc704\ucabd\uc5d0 SET NAMES euckr \uc774 \uc788\uc73c\uba74 \ucda9\ubd84\ud558\ub2e4.
cat backup.data.sql | mysql -p <\/P>
\n

– \uc0ac\uc6a9\uc790\uacc4\uc815\uc744 GRANT ALL \ubb38\uc73c\ub85c \ub2e4\uc2dc \ub9cc\ub4e4\uc5b4\uc900\ub2e4.
root \uc9c0\uc6cc\ubc84\ub9ac\uc9c0 \uc54a\uac8c \uc8fc\uc758. <\/P>
\n


\uc774\uc804 MySQL \uc5d0 charset \uad00\ub828 \uc635\uc158\uc774 \uc5c6\ub2e4\uba74,
\uc2a4\ud0a4\ub9c8\ub294
cat backup.scheme.sql | mysql -p –default-character-set=utf8
\ub370\uc774\ud130\ub294
cat backup.data.sql | mysql -p –default-character-set=euckr
\ub85c \ubcf5\uad6c\ud558\uba74 \ub41c\ub2e4.
\uc2a4\ud0a4\ub9c8\ub294 \uaf2d \uaf3c\uaf3c\ud788 \uc0b4\ud3b4\ubcf4\uace0 \ud3b8\uc9d1\ud558\uc790. <\/P>
\n


2. \ud30c\uc77c
\ubaa8\ub4e0 \ud30c\uc77c\uc758 \ub0b4\uc6a9\uc744 utf8 \ub85c \ubc14\uafb8\uc790.
\uc870\uac74\uc5d0 \ub530\ub77c \ub3d9\uc791\uc774 \ub2ec\ub77c\uc9c0\ubbc0\ub85c php \ub97c \uc774\uc6a9\ud558\uc790.
\/toutf.php
&lt;?php <\/P>
\n

$f = $_SERVER[\\’argv\\’][1];
if(!file_exists($f)) {
&nbsp;&nbsp;&nbsp;&nbsp;echo $f.\\” file not found.\\\\n\\”;
} <\/P>
\n

$text = file_get_contents($text);
$text8 = @iconv(\\’CP949\\’, \\’UTF-8\/\/IGNORE\\’, $text); <\/P>
\n

$cnt = strlen($text);
$cnt8 = strlen($text8);
if($cnt &lt;= $cnt8) {
&nbsp;&nbsp;&nbsp;&nbsp;\/\/ \uc81c\ub300\ub85c \ubcc0\uacbd\uc774 \ub418\uc5c8\ub2e4\uba74 \uc6a9\ub7c9\uc774 \ucee4\uc84c\uc744 \uac83\uc774\ub2e4.
&nbsp;&nbsp;&nbsp;&nbsp;\/\/ \uc6a9\ub7c9\uc774 \uac19\ub2e4\uba74 \ud55c\uae00\uc774 \uc5c6\ub294 \uac83\uc774\ub2e4.
&nbsp;&nbsp;&nbsp;&nbsp;rename($f, $f.\\’.euckr\\’); \/\/ \ubc31\uc5c5
&nbsp;&nbsp;&nbsp;&nbsp;file_put_contents($f, preg_replace(\\’\/charset=euc-kr\/i\\’, \\’charset=utf-8\\’, $text8));
&nbsp;&nbsp;&nbsp;&nbsp;echo $f.\\” file is converted.\\\\n\\”;
} else {
&nbsp;&nbsp;&nbsp;&nbsp;\/\/ \uc6a9\ub7c9\uc774 \uc791\uc544\uc9c4\ub2e4\uba74 \uc798\ubabb\ub41c \uac83\uc774\ub2e4.
&nbsp;&nbsp;&nbsp;&nbsp;$fp = fopen(\\’\/error.txt\\’, \\’a\\’);
&nbsp;&nbsp;&nbsp;&nbsp;fwrite($fp, $f.\\”\\\\n\\<\/A>“);
&nbsp;&nbsp;&nbsp;&nbsp;fclose($fp);
} <\/P>
\n

?&gt; <\/P>
\n

find \/home -type f -name \\”*.php\\” -exec php \/toutf.php \\”{}\\” \\\\;
find \/home -type f -name \\”*.inc\\” -exec php \/toutf.php \\”{}\\” \\\\;
find \/home -type f -name \\”*.txt\\” -exec php \/toutf.php \\”{}\\” \\\\;
find \/home -type f -name \\”*.html\\” -exec php \/toutf.php \\”{}\\” \\\\;
find \/home -type f -name \\”*.htm\\” -exec php \/toutf.php \\”{}\\” \\\\;
find \/home -type f -name \\”*.js\\” -exec php \/toutf.php \\”{}\\” \\\\;
find \/home -type f -name \\”*.css\\” -exec php \/toutf.php \\”{}\\” \\\\; <\/P>
\n


\ud604\uc7ac UTF-8 \uc774 \uc544\ub2cc \uacf3\uc774 \uc5c6\uae30 \ub54c\ubb38\uc5d0,
\uae30\uc5b5\uc744 \ub354\ub4ec\uc5b4 \ub300\ucda9 \ub9cc\ub4e4\uc5c8\ub2e4.
\uc801\uc6a9\uc804 \ubc31\uc5c5\uc740 \ud544\uc218\ub2e4. <\/P>
\n

\uc5d0\ub514\ud130\ub294 EmEditor, DreamWeaver CS3 \ub97c \ucd94\ucc9c\ud55c\ub2e4.
FTP \ub294 WinSCP 4 \ub97c \ucd94\ucc9c\ud55c\ub2e4. \uc708\ub3c4 \ucee4\uba58\ub354 \ubaa8\ub4dc\ub85c \ud558\uba74 \ud30c\uc77c\uba85\uc774 \uc9c0X \uac19\uc544\ub3c4 \uc798 \uc62c\ub9ac\uace0 \ubc1b\uc544\uc9c8 \uac83\uc774\ub2e4. <\/P>
\n

WinSCP \uc758 \uc5d0\ub514\ud130\ub85c EmEditor \ub97c \uc124\uc815\ud558\uba74 \ubb34\uc801\uc774\ub2e4.
EmEditor \ub294 \uae30\ub2a5\uc774 \uc870\uae08 \uc81c\ud55c\ub41c free \ubc84\uc804\uc774 \uc788\ub2e4.
 
&nbsp;&nbsp;License
\ubcf8 \uac8c\uc2dc\ubb3c\uc740 GPL\uc744 \ub530\ub985\ub2c8\ub2e4. [ GPL \uc548\ub0b4 ]&nbsp;&nbsp;
 
 <\/P>
\n

&nbsp;&nbsp;
&nbsp;&nbsp; \uc1a1\ud6a8\uc9c4&nbsp;&nbsp; 07-12-17 11:19&nbsp;&nbsp;
\uc74c… euckr \uc6a9 php \uae00\uc790\uc790\ub974\uae30 \ud568\uc218\uc5d0 \ubb38\uc81c\uac00 \uc788\uc744 \uc218 \uc788\uaca0\ub124\uc694. <\/P>
\n

my.cnf \uc5d0\uc11c default-character-set \ub9cc \uc798 \ub9de\ucdb0\uc8fc\uba74,
DB \uc811\uc18d\uc2dc\uc5d0 set names utf8 \uc740 \uc548\ud574\ub3c4 \ub420\uac81\ub2c8\ub2e4.
\uadf8\ub798\ub3c4 php \uc5d0\ub2e4 \uc800\uac70 \ud55c\uc904 \ucd94\uac00\ud558\ub294\uac8c \uc18d \ud3b8\ud560\uac83 \uac19\ub124\uc694.&nbsp;&nbsp;
 
\uc74c… euckr \uc6a9 php \uae00\uc790\uc790\ub974\uae30 \ud568\uc218\uc5d0 \ubb38\uc81c\uac00 \uc788\uc744 \uc218 \uc788\uaca0\ub124\uc694.<\/P>
\n

my.cnf \uc5d0\uc11c default-character-set \ub9cc \uc798 \ub9de\ucdb0\uc8fc\uba74,
DB \uc811\uc18d\uc2dc\uc5d0 set names utf8 \uc740 \uc548\ud574\ub3c4 \ub420\uac81\ub2c8\ub2e4.
\uadf8\ub798\ub3c4 php \uc5d0\ub2e4 \uc800\uac70 \ud55c\uc904 \ucd94\uac00\ud558\ub294\uac8c \uc18d \ud3b8\ud560\uac83 \uac19\ub124\uc694.
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp; \uc804\uc9c4\ud558\ub294\uc544\ub974\uace0&nbsp;&nbsp; 07-12-17 12:07&nbsp;&nbsp;
\uc5ec\ub7ec \ub3c4\uba54\uc778\uc744 \uc0ac\uc6a9\ud560\ub54c\ub97c \ub300\ube44\ud574\uc11c \ud55c\uc904\ucd94\uac00\uac00 \uac00\uc7a5 \uc18d \ud3b8\ud55c\ub4ef \uc2f6\ub124\uc694.&nbsp;&nbsp;
 
\uc5ec\ub7ec \ub3c4\uba54\uc778\uc744 \uc0ac\uc6a9\ud560\ub54c\ub97c \ub300\ube44\ud574\uc11c \ud55c\uc904\ucd94\uac00\uac00 \uac00\uc7a5 \uc18d \ud3b8\ud55c\ub4ef \uc2f6\ub124\uc694.
&nbsp;&nbsp;
&nbsp;&nbsp; \uc2e0\uc758\uc190&nbsp;&nbsp; 07-12-17 11:26&nbsp;&nbsp;
\uc2a4\ud06c\ub7a9\ud588\uc2b5\ub2c8\ub2e4. \uc774\ubc88 \uc11c\ubc84\uc5c5\uae00\ub54c \uc368\uba39\uc5b4\uc57c\uaca0\ub124\uc694.. \uc88b\uc740\uc815\ubcf4 \uac10\uc0ac\ud569\ub2c8\ub2e4.^^&nbsp;&nbsp;
 
\uc2a4\ud06c\ub7a9\ud588\uc2b5\ub2c8\ub2e4. \uc774\ubc88 \uc11c\ubc84\uc5c5\uae00\ub54c \uc368\uba39\uc5b4\uc57c\uaca0\ub124\uc694.. \uc88b\uc740\uc815\ubcf4 \uac10\uc0ac\ud569\ub2c8\ub2e4.^^
&nbsp;&nbsp;
&nbsp;&nbsp; \ud5c8\uc0dd&nbsp;&nbsp; 07-12-17 11:27&nbsp;&nbsp;
\uc608\uc804\uc5d0 UTF-8\ub85c \uc774\uc804\ud560\ub54c \ud30c\uc77c\uc744 \ud558\ub098\ud558\ub098 \ub530\ub85c \uc5f4\uc5b4\uc11c \uc18d\uc131\uc744 \ubcc0\uacbd\ud574\uc92c\ub358 \uae30\uc5b5\uc774 \uc788\ub294\ub370…
\uc774\ub807\uac8c \ud55c\ubc29\uc5d0 \ud574\uacb0\uac00\ub2a5\ud558\uad70\uc694… \uc5ed\uc2dc \ubb34\uc2dd\ud558\uba74 \uc190\ubc1c\uc774 \uace0\uc0dd~&nbsp;&nbsp;
 
\uc608\uc804\uc5d0 UTF-8\ub85c \uc774\uc804\ud560\ub54c \ud30c\uc77c\uc744 \ud558\ub098\ud558\ub098 \ub530\ub85c \uc5f4\uc5b4\uc11c \uc18d\uc131\uc744 \ubcc0\uacbd\ud574\uc92c\ub358 \uae30\uc5b5\uc774 \uc788\ub294\ub370…
\uc774\ub807\uac8c \ud55c\ubc29\uc5d0 \ud574\uacb0\uac00\ub2a5\ud558\uad70\uc694… \uc5ed\uc2dc \ubb34\uc2dd\ud558\uba74 \uc190\ubc1c\uc774 \uace0\uc0dd~
&nbsp;&nbsp;
&nbsp;&nbsp; \uc1a1\ud6a8\uc9c4&nbsp;&nbsp; 07-12-17 11:41&nbsp;&nbsp;
\uc0dd\uac01\ud574 \ubcf4\ub2c8 iconv \ub85c \ud574\uc57c \uc6d0\ud558\ub294 \ub3d9\uc791\uc774 \ub418\uc5b4 \uc0b4\uc9dd \uc218\uc815\ud588\uc2b5\ub2c8\ub2e4.&nbsp;&nbsp;
 
\uc0dd\uac01\ud574 \ubcf4\ub2c8 iconv \ub85c \ud574\uc57c \uc6d0\ud558\ub294 \ub3d9\uc791\uc774 \ub418\uc5b4 \uc0b4\uc9dd \uc218\uc815\ud588\uc2b5\ub2c8\ub2e4.
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp; \uc804\uc9c4\ud558\ub294\uc544\ub974\uace0&nbsp;&nbsp; 07-12-17 12:08&nbsp;&nbsp;
\uca5d \uadfc\ub370… \uc774\uc655\uc774\uba74 \ud398\uc774\uc9c0\uc18d\uc758 \uba54\ud0c0\ud0dc\uadf8\ub3c4… \u314e\u314e\u314e&nbsp;&nbsp;
 
\uca5d \uadfc\ub370… \uc774\uc655\uc774\uba74 \ud398\uc774\uc9c0\uc18d\uc758 \uba54\ud0c0\ud0dc\uadf8\ub3c4… \u314e\u314e\u314e
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp; \uc1a1\ud6a8\uc9c4&nbsp;&nbsp; 07-12-17 12:51&nbsp;&nbsp;
\uadf8\uac74 \ub418\uc5b4 \uc788\uc5b4\uc694.\u314e\u314e&nbsp;&nbsp;
 
\uadf8\uac74 \ub418\uc5b4 \uc788\uc5b4\uc694.\u314e\u314e
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp; \uc804\uc9c4\ud558\ub294\uc544\ub974\uace0&nbsp;&nbsp; 07-12-17 14:27&nbsp;&nbsp;
\ud5c9… \uae00\ucfe4\uc694.. \ucc29\uac01\ud588\ub124\uc694.. \uc694\uc998 \ucc29\uac01\uc744 \uc790\uc8fc\ud558\ub294\uac78 \ubcf4\ub2c8… \uba85\ud1f4\ud560\ub54c\uac00 \ub418\uc5c8\ub098 \uca5d…&nbsp;&nbsp;
 
\ud5c9… \uae00\ucfe4\uc694.. \ucc29\uac01\ud588\ub124\uc694.. \uc694\uc998 \ucc29\uac01\uc744 \uc790\uc8fc\ud558\ub294\uac78 \ubcf4\ub2c8… \uba85\ud1f4\ud560\ub54c\uac00 \ub418\uc5c8\ub098 \uca5d…
&nbsp;&nbsp;
&nbsp;&nbsp; x\ub51c\ub9c8&nbsp;&nbsp; 07-12-17 11:46&nbsp;&nbsp;
\uc88b\uc740 \uc815\ubcf4 \uac10\uc0ac \ub4dc\ub9bd\ub2c8\ub2e4.
\uac1c\ubc1c \ud55c\uac83 UTF\uc6a9\uc73c\ub85c \ubcc0\ud658 \ud560\ub824\uace0 \uacc4\ud68d\uc911\uc774\uc5c8\ub294\ub370.. \uc27d\uac8c \ucc98\ub9ac \ub420\uac83 \uac19\ub124\uc694.&nbsp;&nbsp;
 
\uc88b\uc740 \uc815\ubcf4 \uac10\uc0ac \ub4dc\ub9bd\ub2c8\ub2e4.
\uac1c\ubc1c \ud55c\uac83 UTF\uc6a9\uc73c\ub85c \ubcc0\ud658 \ud560\ub824\uace0 \uacc4\ud68d\uc911\uc774\uc5c8\ub294\ub370.. \uc27d\uac8c \ucc98\ub9ac \ub420\uac83 \uac19\ub124\uc694.
&nbsp;&nbsp;
&nbsp;&nbsp; \uc804\uc9c4\ud558\ub294\uc544\ub974\uace0&nbsp;&nbsp; 07-12-17 12:11&nbsp;&nbsp;
\ucc38\uace0\ub85c \uc800\ub294 euckr\uc5d0\uc11c \uc62e\uae38\ub54c sql \ud654\uc77c \ub364\ud504 \ubc1b\uc544\uc11c set names euckr \uc8fc\uace0 utf8 \uc774 \uc544\ub2cc \ubb38\uc11c\ub85c \uc62c\ub838\ub354\ub2c8
\uc5d0\ub7ec\uac00 \uc0dd\uacbc\uc2b5\ub2c8\ub2e4. \uadf8\ub798\uc11c \uc544\uc608 utf8\ub85c sql \ud30c\uc77c\uc744 \ubcc0\uacbd\ud558\uace0 \uc62c\ub9bd\ub2c8\ub2e4.&nbsp;&nbsp;
 
\ucc38\uace0\ub85c \uc800\ub294 euckr\uc5d0\uc11c \uc62e\uae38\ub54c sql \ud654\uc77c \ub364\ud504 \ubc1b\uc544\uc11c set names euckr \uc8fc\uace0 utf8 \uc774 \uc544\ub2cc \ubb38\uc11c\ub85c \uc62c\ub838\ub354\ub2c8
\uc5d0\ub7ec\uac00 \uc0dd\uacbc\uc2b5\ub2c8\ub2e4. \uadf8\ub798\uc11c \uc544\uc608 utf8\ub85c sql \ud30c\uc77c\uc744 \ubcc0\uacbd\ud558\uace0 \uc62c\ub9bd\ub2c8\ub2e4.
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp; \uc1a1\ud6a8\uc9c4&nbsp;&nbsp; 07-12-17 12:54&nbsp;&nbsp;
euckr \ub85c \ud558\ub294 \uc774\uc720\ub294,
\ud754\ud558\uc9c0\ub294 \uc54a\uc9c0\ub9cc euckr \uc758 \uba40\ud2f0\ubc14\uc774\ud2b8 \ucf54\ub4dc \ub9c8\uc800 escape \uc2dc\ucf1c\ubc84\ub9ac\ub294 \uac83\uc774 \uc788\uc2b5\ub2c8\ub2e4.
\uc608\ub97c \ub4e4\uc790\uba74, \u3142\u315e\u313a \uc778\ub370 ?\\\\\\’? \uc774\ub7f0\uc2dd\uc774\ub784\uae4c\uc694?
\uc774\uac74 \ubcc0\ud658\uc774 \uc548\ub418\uc9c0\uc694.
\uadf8\ub7f0\ub370, euckr \ub85c \ub123\uc73c\uba74 \uc6d0\ub798 \uadf8\ub7f0 escape \uae30 \ub54c\ubb38\uc5d0 \ub3d9\uc791\uc744 \ud569\ub2c8\ub2e4.
\uc544\ub9c8 \uc624\ub958\uac00 \uc2a4\ud0a4\ub9c8\uc5d0\uc11c \ub0ac\uc744\ub4ef \ud569\ub2c8\ub2e4.
\uc608\uc81c\uc5d0\uc11c\ucc98\ub7fc \ubd84\ub9ac\ud558\uc5ec \ud574 \ubcf4\uc2dc\uba74 \ubb38\uc81c \uc5c6\uc744\ub4ef \ud558\ub124\uc694.&nbsp;&nbsp;
 
euckr \ub85c \ud558\ub294 \uc774\uc720\ub294,
\ud754\ud558\uc9c0\ub294 \uc54a\uc9c0\ub9cc euckr \uc758 \uba40\ud2f0\ubc14\uc774\ud2b8 \ucf54\ub4dc \ub9c8\uc800 escape \uc2dc\ucf1c\ubc84\ub9ac\ub294 \uac83\uc774 \uc788\uc2b5\ub2c8\ub2e4.
\uc608\ub97c \ub4e4\uc790\uba74, \u3142\u315e\u313a \uc778\ub370 ?\\\\\\’? \uc774\ub7f0\uc2dd\uc774\ub784\uae4c\uc694?
\uc774\uac74 \ubcc0\ud658\uc774 \uc548\ub418\uc9c0\uc694.
\uadf8\ub7f0\ub370, euckr \ub85c \ub123\uc73c\uba74 \uc6d0\ub798 \uadf8\ub7f0 escape \uae30 \ub54c\ubb38\uc5d0 \ub3d9\uc791\uc744 \ud569\ub2c8\ub2e4.
\uc544\ub9c8 \uc624\ub958\uac00 \uc2a4\ud0a4\ub9c8\uc5d0\uc11c \ub0ac\uc744\ub4ef \ud569\ub2c8\ub2e4.
\uc608\uc81c\uc5d0\uc11c\ucc98\ub7fc \ubd84\ub9ac\ud558\uc5ec \ud574 \ubcf4\uc2dc\uba74 \ubb38\uc81c \uc5c6\uc744\ub4ef \ud558\ub124\uc694.
&nbsp;&nbsp;
&nbsp;&nbsp; \ub0ad\ub9dd\ubc31\uc218&nbsp;&nbsp; 07-12-17 12:35&nbsp;&nbsp;
\uc804\uccb4\uc801\uc73c\ub85c
\ubc84\uc804 5.x \ub85c\uc758 \uc774\uc804\uc5d0 \ud574\ub2f9\ud558\ub294 \uac83\uacfc UTF-8\ub85c\uc758 \uc774\uc804\uc5d0 \ud574\ub2f9\ud558\ub294 \uac83\uc744 \uc880 \uac00\ub9b4 \ud544\uc694\uac00 \uc788\uaca0\ub294\ub370\uc694.
\uadf8\ub9ac\uace0 \uc774\uc655\uc774\uba74 \uac01 \uc218\uc815\ud56d\ubaa9\uc5d0 \ub300\ud55c \uc124\uba85\ub3c4. ^^;;; <\/P>
\n

\uc9c4\uc9dc \uad81\uae08\ud55c\uac74 BINARY \ub97c \uc65c \uc5c6\uc560\uc57c\ud558\ub294\uc9c0 \uad81\uae08\ud569\ub2c8\ub2e4.
\uc804\ubd80\ud130 \uad81\uae08\ud588\ub294\ub370 \uc544\uc9c1\ub3c4 \uc774\uc720\ub97c \ubaa8\ub974\uaca0\ub124\uc694. \ub9e4\ub274\uc5bc\uc774\ub098 MySQL \uc0ac\uc774\ud2b8\uc124\uba85\ub3c4 \uc560\ub9e4\ud558\uace0. \u314b <\/P>
\n

\uc81c\uac00 \uc0dd\uac01\ud558\ub294 \uc81c\uc77c \uac04\ub2e8\ud55c \ubc29\ubc95\uc740 \ubc00\uc5b4\ub123\uc744\ub54c setCharacter \uc9c0\uc815\ud558\ub294 \uac83\uc774\uc544\ub2c8\ub77c
\ubc00\uc5b4\ub123\ub294 \uac83\uc740 \uadf8\ub300\ub85c \uac4d sql\ub85c \ubc00\uc5b4\ub123\uace0
\uc2e0\ubc84\uc83c\uc758 Database \ub9cc(\uc2a4\ud0a4\ub9c8\uc5c6\uc774) UTF-8 \ub85c\uc0dd\uc131\ud558\uace0 \ub098\uba38\uc9c0 \uadf8\ub300\ub85c \uac4d \ub2e4 \ubc00\uc5b4\ub123\ub294\uac83\uc785\ub2c8\ub2e4.
\ub4e4\uc5b4\uac08\ub54c \uc54c\uc544\uc11c UTF-8 \ubc14\ub00c\ub354\uad70\uc694.
(BINARY \ub294 \ubc14\uafb8\uc9c0 \uc54a\uc558\ub294\ub370 \uad1c\ucc2e\ub354\uad70\uc694. \uc55e\uc73c\ub85c \ubb34\uc2a8 \ubb38\uc81c\uac00 \uc788\uc744\uc9c0 \ubaa8\ub974\uaca0\uc9c0\ub9cc \u3161\u3161;;) <\/P>
\n

\uafb8\ubc85~!&nbsp;&nbsp;
 
\uc804\uccb4\uc801\uc73c\ub85c
\ubc84\uc804 5.x \ub85c\uc758 \uc774\uc804\uc5d0 \ud574\ub2f9\ud558\ub294 \uac83\uacfc UTF-8\ub85c\uc758 \uc774\uc804\uc5d0 \ud574\ub2f9\ud558\ub294 \uac83\uc744 \uc880 \uac00\ub9b4 \ud544\uc694\uac00 \uc788\uaca0\ub294\ub370\uc694.
\uadf8\ub9ac\uace0 \uc774\uc655\uc774\uba74 \uac01 \uc218\uc815\ud56d\ubaa9\uc5d0 \ub300\ud55c \uc124\uba85\ub3c4. ^^;;;<\/P>
\n

\uc9c4\uc9dc \uad81\uae08\ud55c\uac74 BINARY \ub97c \uc65c \uc5c6\uc560\uc57c\ud558\ub294\uc9c0 \uad81\uae08\ud569\ub2c8\ub2e4.
\uc804\ubd80\ud130 \uad81\uae08\ud588\ub294\ub370 \uc544\uc9c1\ub3c4 \uc774\uc720\ub97c \ubaa8\ub974\uaca0\ub124\uc694. \ub9e4\ub274\uc5bc\uc774\ub098 MySQL \uc0ac\uc774\ud2b8\uc124\uba85\ub3c4 \uc560\ub9e4\ud558\uace0. \u314b<\/P>
\n

\uc81c\uac00 \uc0dd\uac01\ud558\ub294 \uc81c\uc77c \uac04\ub2e8\ud55c \ubc29\ubc95\uc740 \ubc00\uc5b4\ub123\uc744\ub54c setCharacter \uc9c0\uc815\ud558\ub294 \uac83\uc774\uc544\ub2c8\ub77c
\ubc00\uc5b4\ub123\ub294 \uac83\uc740 \uadf8\ub300\ub85c \uac4d sql\ub85c \ubc00\uc5b4\ub123\uace0
\uc2e0\ubc84\uc83c\uc758 Database \ub9cc(\uc2a4\ud0a4\ub9c8\uc5c6\uc774) UTF-8 \ub85c\uc0dd\uc131\ud558\uace0 \ub098\uba38\uc9c0 \uadf8\ub300\ub85c \uac4d \ub2e4 \ubc00\uc5b4\ub123\ub294\uac83\uc785\ub2c8\ub2e4.
\ub4e4\uc5b4\uac08\ub54c \uc54c\uc544\uc11c UTF-8 \ubc14\ub00c\ub354\uad70\uc694.
(BINARY \ub294 \ubc14\uafb8\uc9c0 \uc54a\uc558\ub294\ub370 \uad1c\ucc2e\ub354\uad70\uc694. \uc55e\uc73c\ub85c \ubb34\uc2a8 \ubb38\uc81c\uac00 \uc788\uc744\uc9c0 \ubaa8\ub974\uaca0\uc9c0\ub9cc \u3161\u3161;;)<\/P>
\n

\uafb8\ubc85~!
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp; \uc1a1\ud6a8\uc9c4&nbsp;&nbsp; 07-12-17 12:54&nbsp;&nbsp;
BINARY \ub294 \ub9d0 \uadf8\ub300\ub85c \ubc14\uc774\ub108\ub9ac \uc785\ub2c8\ub2e4.
\uce90\ub9ad\ud130 \ucde8\uae09\uc744 \uc548\ud558\uc9c0\uc694. \uce90\ub9ad\ud130\uc14b \ubcc0\ud658\uc774 \uc548\ub418\uc694.
\uad6c \ubc84\uc804\uc5d0\uc11c BINARY \ub97c \uc37c\ub358 \uc774\uc720\uc911 \uac00\uc7a5 \ud070\uac83\uc774,
latin1 \uc73c\ub85c \ud574\uc11c \uc815\ub82c\uc774 \uc5c9\ub9dd\uc774 \ub418\uae30 \ub54c\ubb38\uc774\uc5c8\uc9c0\uc694. <\/P>
\n

5.x \ub294 \ud544\uc218\ub77c\uace0 \uc0dd\uac01\ud574\uc11c \ub098\ub204\uc9c0\ub294 \uc54a\uace0 \ub2f9\uc758\uc131\uc5d0 \ub300\ud55c \uc124\uba85\uc744 \ucd94\uac00\ud588\uc2b5\ub2c8\ub2e4.&nbsp;&nbsp;
 
BINARY \ub294 \ub9d0 \uadf8\ub300\ub85c \ubc14\uc774\ub108\ub9ac \uc785\ub2c8\ub2e4.
\uce90\ub9ad\ud130 \ucde8\uae09\uc744 \uc548\ud558\uc9c0\uc694. \uce90\ub9ad\ud130\uc14b \ubcc0\ud658\uc774 \uc548\ub418\uc694.
\uad6c \ubc84\uc804\uc5d0\uc11c BINARY \ub97c \uc37c\ub358 \uc774\uc720\uc911 \uac00\uc7a5 \ud070\uac83\uc774,
latin1 \uc73c\ub85c \ud574\uc11c \uc815\ub82c\uc774 \uc5c9\ub9dd\uc774 \ub418\uae30 \ub54c\ubb38\uc774\uc5c8\uc9c0\uc694.<\/P>
\n

5.x \ub294 \ud544\uc218\ub77c\uace0 \uc0dd\uac01\ud574\uc11c \ub098\ub204\uc9c0\ub294 \uc54a\uace0 \ub2f9\uc758\uc131\uc5d0 \ub300\ud55c \uc124\uba85\uc744 \ucd94\uac00\ud588\uc2b5\ub2c8\ub2e4.
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp; \ub0ad\ub9dd\ubc31\uc218&nbsp;&nbsp; 07-12-17 13:02&nbsp;&nbsp;
\uadf8\ub7fc binary packing \uc774 \uc5b4\ub5bb\uac8c \uc774\ub8e8\uc5b4\uc9c0\ub294\uc9c0 \uad81\uae08\ud558\uad70\uc694. unpacking \uc740?
(\uadf8\ub7f0\ub370 \uc65c \uc800\ub294 \uc81c\ub300\ub85c \ub098\uc62c\uae4c\uc694? \u3161\u3161;) <\/P>
\n

ps; \uc9d0 free emeditor \uae30\ub2a5\uc81c\ud55c\uc774 \ubb50\uc8e0? \uc4f0\ub2e4\uac00 \uc801\uc751\uc548\ub418\uc11c \ud3ec\uae30\ud55c 1\u4eba&nbsp;&nbsp;
 
\uadf8\ub7fc binary packing \uc774 \uc5b4\ub5bb\uac8c \uc774\ub8e8\uc5b4\uc9c0\ub294\uc9c0 \uad81\uae08\ud558\uad70\uc694. unpacking \uc740?
(\uadf8\ub7f0\ub370 \uc65c \uc800\ub294 \uc81c\ub300\ub85c \ub098\uc62c\uae4c\uc694? \u3161\u3161;)<\/P>
\n

ps; \uc9d0 free emeditor \uae30\ub2a5\uc81c\ud55c\uc774 \ubb50\uc8e0? \uc4f0\ub2e4\uac00 \uc801\uc751\uc548\ub418\uc11c \ud3ec\uae30\ud55c 1\u4eba
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp; \uc1a1\ud6a8\uc9c4&nbsp;&nbsp; 07-12-17 13:12&nbsp;&nbsp;
PostgreSQL \uacfc\ub294 \uac1c\ub150\uc774 \uc870\uae08 \ub2e4\ub985\ub2c8\ub2e4.
pgsql \uc5d0\uc11c\ub294 bytea \ub85c \ud328\ud0b9\uc744 \ud558\uc9c0\ub9cc,
MySQL \uc5d0\uc11c\ub294 \ud328\ud0b9\ud558\ub294\uac83\uc774 \uc544\ub2c8\uace0, \uadf8\ub0e5 binary \ucde8\uae09\ub9cc \ud574 \uc8fc\ub294 \uac83\uc785\ub2c8\ub2e4.
varchar(1) binary \ub294 1byte \ub97c \uc758\ubbf8\ud558\uac8c \ub418\uaca0\uc8e0. <\/P>
\n

utf-8 \ub85c\uc758 \uc774\uc804\uc2dc\uc5d0 iconv \ub85c \ubcc0\ud658\ud558\uac70\ub098 \ud55c \uc801\uc774 \uc5c6\ub294\ub370,
set names euckr \ub85c \uc798 \ub4e4\uc5b4\uac14\ub2e4\uba74,
php \uc5d0\uc11c\ub3c4 set names euckr \uc778 \uc0c1\ud0dc\uac00 \uc544\ub2cc\uc9c0 \ud655\uc778\uc774 \ud544\uc694\ud558\uaca0\uc2b5\ub2c8\ub2e4. <\/P>
\n

emeditor free \ub294 tools \uc5c6\uace0 (diff \ub4f1), \ud0d0X\uae30 \ub9c8\uc6b0\uc2a4 \uc6b0\ud074\ub9ad\uc5d0 \uba54\ub274 \uc5c6\ub2e4\ub294\uac83 \uc815\ub3c4 \uc785\ub2c8\ub2e4.
\ud2b8\ub808\uc774 \uc544\uc774\ucf58 \uc81c\uacf5\ub3c4 \uc548\ud558\ub358\uac00…
\uae30\ubcf8\uc801\uc73c\ub85c utf-8 \uc774 \uc544\ub2c8\uae30 \ub54c\ubb38\uc5d0 \uc635\uc158\uc740 \uc870\uae08 \uc190\ubd10\uc904 \ud544\uc694\uac00 \uc788\uc2b5\ub2c8\ub2e4.
\uac00\uc7a5 \uc88b\uac8c \uc0dd\uac01\ud558\ub294 \uae30\ub2a5\uc774 \uc6b0\ud558\ub2e8\uc758 \ud604\uc7ac \uce90\ub9ad\ud130\uc14b \ud45c\uc2dc\ub97c \ub354\ube14\ud074\ub9ad\ud558\uba74,
\ubc14\ub85c \uc5b4\ub5a4 \uce90\ub9ad\ud130\uc14b\uc73c\ub85c\ub4e0 \ub2e4\uc2dc \ubd88\ub7ec\uc62c \uc218 \uc788\ub2e4\ub294 \uac83\uc785\ub2c8\ub2e4.
\ub2e4\ub978 \uc774\ub984\uc73c\ub85c \uc800\uc7a5\uc2dc\uc5d0 \uc5b4\ub5a4 \uce90\ub9ad\ud130\uc14b\uc73c\ub85c\ub3c4 \ubcc0\ud658\ud560 \uc218 \uc788\uace0\uc694.&nbsp;&nbsp;
 
PostgreSQL \uacfc\ub294 \uac1c\ub150\uc774 \uc870\uae08 \ub2e4\ub985\ub2c8\ub2e4.
pgsql \uc5d0\uc11c\ub294 bytea \ub85c \ud328\ud0b9\uc744 \ud558\uc9c0\ub9cc,
MySQL \uc5d0\uc11c\ub294 \ud328\ud0b9\ud558\ub294\uac83\uc774 \uc544\ub2c8\uace0, \uadf8\ub0e5 binary \ucde8\uae09\ub9cc \ud574 \uc8fc\ub294 \uac83\uc785\ub2c8\ub2e4.
varchar(1) binary \ub294 1byte \ub97c \uc758\ubbf8\ud558\uac8c \ub418\uaca0\uc8e0.<\/P>
\n

utf-8 \ub85c\uc758 \uc774\uc804\uc2dc\uc5d0 iconv \ub85c \ubcc0\ud658\ud558\uac70\ub098 \ud55c \uc801\uc774 \uc5c6\ub294\ub370,
set names euckr \ub85c \uc798 \ub4e4\uc5b4\uac14\ub2e4\uba74,
php \uc5d0\uc11c\ub3c4 set names euckr \uc778 \uc0c1\ud0dc\uac00 \uc544\ub2cc\uc9c0 \ud655\uc778\uc774 \ud544\uc694\ud558\uaca0\uc2b5\ub2c8\ub2e4.<\/P>
\n

emeditor free \ub294 tools \uc5c6\uace0 (diff \ub4f1), \ud0d0X\uae30 \ub9c8\uc6b0\uc2a4 \uc6b0\ud074\ub9ad\uc5d0 \uba54\ub274 \uc5c6\ub2e4\ub294\uac83 \uc815\ub3c4 \uc785\ub2c8\ub2e4.
\ud2b8\ub808\uc774 \uc544\uc774\ucf58 \uc81c\uacf5\ub3c4 \uc548\ud558\ub358\uac00…
\uae30\ubcf8\uc801\uc73c\ub85c utf-8 \uc774 \uc544\ub2c8\uae30 \ub54c\ubb38\uc5d0 \uc635\uc158\uc740 \uc870\uae08 \uc190\ubd10\uc904 \ud544\uc694\uac00 \uc788\uc2b5\ub2c8\ub2e4.
\uac00\uc7a5 \uc88b\uac8c \uc0dd\uac01\ud558\ub294 \uae30\ub2a5\uc774 \uc6b0\ud558\ub2e8\uc758 \ud604\uc7ac \uce90\ub9ad\ud130\uc14b \ud45c\uc2dc\ub97c \ub354\ube14\ud074\ub9ad\ud558\uba74,
\ubc14\ub85c \uc5b4\ub5a4 \uce90\ub9ad\ud130\uc14b\uc73c\ub85c\ub4e0 \ub2e4\uc2dc \ubd88\ub7ec\uc62c \uc218 \uc788\ub2e4\ub294 \uac83\uc785\ub2c8\ub2e4.
\ub2e4\ub978 \uc774\ub984\uc73c\ub85c \uc800\uc7a5\uc2dc\uc5d0 \uc5b4\ub5a4 \uce90\ub9ad\ud130\uc14b\uc73c\ub85c\ub3c4 \ubcc0\ud658\ud560 \uc218 \uc788\uace0\uc694.
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp; \ub0ad\ub9dd\ubc31\uc218&nbsp;&nbsp; 07-12-17 13:22&nbsp;&nbsp;
\uc624\ud638~ \uc624\ud638~ \uc5f0\ubc1c\uc774\uad70\uc694. \uac10\uc0ac\ud569\ub2c8\ub2e4. \uc2a4\ud2b8\ub7a9\ub3c4 \ud558\uad6c\uc694. ^^;&nbsp;&nbsp;
 
\uc624\ud638~ \uc624\ud638~ \uc5f0\ubc1c\uc774\uad70\uc694. \uac10\uc0ac\ud569\ub2c8\ub2e4. \uc2a4\ud2b8\ub7a9\ub3c4 \ud558\uad6c\uc694. ^^;
&nbsp;&nbsp;
&nbsp;&nbsp; \ud558\ub298\ucc98\ub7fc\u2122&nbsp;&nbsp; 07-12-17 13:09&nbsp;&nbsp;
\uc774\uc81c \uc2a4\ucfe8\uc774 utf-8\ub85c \uac00\ub294 \uc77c\ub9cc \ub0a8\uc740\uac70\uc8e0?&nbsp;&nbsp;
 
\uc774\uc81c \uc2a4\ucfe8\uc774 utf-8\ub85c \uac00\ub294 \uc77c\ub9cc \ub0a8\uc740\uac70\uc8e0?
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp; \ub0ad\ub9dd\ubc31\uc218&nbsp;&nbsp; 07-12-17 13:21&nbsp;&nbsp;
\u314e\u314e\u314e\u314e.&nbsp;&nbsp;
 
\u314e\u314e\u314e\u314e.
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp; \uc804\uc9c4\ud558\ub294\uc544\ub974\uace0&nbsp;&nbsp; 07-12-17 14:28&nbsp;&nbsp;
\uc2a4\ucfe8\uc740 euc-kr \uc600\uad70\uc694…&nbsp;&nbsp;
 
_PS||MG__PS||MG__PS||MG__PS||MG__PS||MG__PS||MG__PS||MG__PS||MG__PS||MG__PS||MG__PS||MG_<\/P><\/p>\n","protected":false},"excerpt":{"rendered":"

[\uc11c\ubc84\uc6b4\uc601] utf-8 \ub85c \uc774\uc804\ud558\uae30.[\uc218\uc815]&nbsp;&nbsp;   \uae00\uc4f4\uc774&nbsp;&nbsp; \uc1a1\ud6a8\uc9c4&nbsp;&nbsp;\ub0a0 \uc9dc 07-12-17 11:15&nbsp;&nbsp;\uc870 \ud68c 613   utf-8 \ub85c \uc774\uc804\ud558\uae30. 1. MySQL – euckr \uc2a4\ud0a4\ub9c8 \ubc31\uc5c5 mysqldump –all-databases –no-data –set-charset=euckr -p &gt; backup.scheme.sql – euckr \uc790\ub8cc \ubc31\uc5c5 mysqldump –all-databases –no-create-db –set-charset=euckr -p &gt; backup.data.sql \uc6ec\ub9cc\ud558\uba74 \uc0ac\uc6a9\uc790\uacc4\uc815 \uc815\ubcf4\ub294 \uc554\ud638\uae4c\uc9c0 \ud655\uc2e4\ud558\uac8c \uc54c\uace0\uc788\uc790. GRANT ALL \ucffc\ub9ac\ubb38\uc744 \uc9c1\uc811 \uc791\uc131\ud558\uc5ec \uac00\uc9c0\uace0 \uc788\uc790. – UTF-8 \uc744 \uc81c\ub300\ub85c […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[51],"tags":[93,94],"class_list":["post-1720","post","type-post","status-publish","format-standard","hentry","category-papa-php","tag-utf-8","tag-94"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/jblove.net\/index.php?rest_route=\/wp\/v2\/posts\/1720","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jblove.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jblove.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jblove.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jblove.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1720"}],"version-history":[{"count":0,"href":"https:\/\/jblove.net\/index.php?rest_route=\/wp\/v2\/posts\/1720\/revisions"}],"wp:attachment":[{"href":"https:\/\/jblove.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1720"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jblove.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1720"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jblove.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1720"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}