[bjlug-ml] Re: MySQLãæååã

[Naoyuki Tai <ntai@xxxxxxxxxxxxxx>]

Daigo Fujiwara wrote:

> ãããããæçãããæååããèããããããããããããããã

åãèããããããããããæåã

INSERT INTO `wp_comments` VALUES (2, 3, 'MasatoÂÃÅÃÃÃÅÃÃÃUjigawa'

ããããã
Masato ã Ujigawa ãéã

c3 a3 e2 82 ac e2 82 ac

ããããããããäãããããããæåã iso-8859-1 ãã utf-8 ããåæã 
èãããã
ããæãããããããããããããïãããããããæãããããããïããã 
ããããã
ããããèãããããã

'c3 a3'
'e2 82 ac'
'e2 82 ac'

ããããããããããããæããããã
ãã e2 82 ac ã utf-8 ãã euro symbol ãã Windows code page 1252 ããã
ããããããã 80 ããããããããããããããããããããããããåã 
ãããã

e3: c3 a3
80: e2 82 ac
80: e2 82 ac

ããã Unicode/utf-8 ããããã ãã Windows-1252 ãããããããåå 
utf-8 ã
åæããããããããããææãããããã

éåæãããã

iconv -f utf-8 -t windows-1252 foo.sql > bar.sql

ãçæãäéãåãæããããããããèãããããããã
äããããããããããæéãåãããããããääãèæãããããã

ãããããã phpMyAdmin ãäãããããçæ mysqldump ãããããäããã
dump ããããããããããåãããããããã phpMyAdmin ãããããããã
utf-8 ããæããããããããååãutf-8 ãæåãããããããããããåæ
ãèããããããutf-8 ãæåãããããããççã mysql ããããããã
ããããããããããããããåãããæããããããã
dump ããããã AIM ãããããããçæããããäääãåãããããåã
éèãããããããããããããã

--
+--+--+   |  |      --+--   --    Peace on Earth
|  |  |  -+--+-      +-+   ---
+--+--+ --+--+--   | |=|     /
|  |  |   |  |     | +-+    /     Naoyuki "Tai" Tai
+--+--+     _|     +----- ------  ntai a t smartfruit d o t com