SHOW VARIABLES LIKE "%character_set%"
array(2) {
["Variable_name"]=>
string(20) "character_set_client"
["Value"]=>
string(6) "latin1"
}
array(2) {
["Variable_name"]=>
string(24) "character_set_connection"
["Value"]=>
string(6) "latin1"
}
array(2) {
["Variable_name"]=>
string(22) "character_set_database"
["Value"]=>
string(4) "utf8"
}
array(2) {
["Variable_name"]=>
string(24) "character_set_filesystem"
["Value"]=>
string(6) "binary"
}
array(2) {
["Variable_name"]=>
string(21) "character_set_results"
["Value"]=>
string(6) "latin1"
}
array(2) {
["Variable_name"]=>
string(20) "character_set_server"
["Value"]=>
string(6) "latin1"
}
array(2) {
["Variable_name"]=>
string(20) "character_set_system"
["Value"]=>
string(4) "utf8"
}
array(2) {
["Variable_name"]=>
string(18) "character_sets_dir"
["Value"]=>
string(32) "/usr/local/share/mysql/charsets/"
}
Experiment 1
- Select Japanese data from MySQL, print the data returned by mysql_result()
- 姫川 かずみ（ひめかわ かずみ）
- Get HEX Value of string
- e5a7abe5b79de38080e3818be3819ae381bfefbc88e381b2e38281e3818be3828fe38080e3818be3819ae381bfefbc89
Experiment 2
- Within MySQL, select HEX value of Japanese data
- C3A5C2A7C2ABC3A5C2B7C29DC3A3E282ACE282ACC3A3C281E280B9C3A3C281C5A1C3A3C281C2BFC3AFC2BCCB86C3A3C281C2B2C3A3E2809AC281C3A3C281E280B9C3A3E2809AC28FC3A3E282ACE282ACC3A3C281E280B9C3A3C281C5A1C3A3C281C2BFC3AFC2BCE280B0
Experiment 3
- CONVERT(CAST(CONVERT(japanese USING latin1) AS BINARY) USING utf8)
- ????????????????
- Run bin2hex on this
- 3f3f3f3f3f3f3f3f3f3f3f3f3f3f3f3f
Experiment 4
- HEX(CONVERT(CAST(CONVERT(japanese USING latin1) AS BINARY)USING utf8))
- E5A7ABE5B79DE38080E3818BE3819AE381BFEFBC88E381B2E38281E3818BE3828FE38080E3818BE3819AE381BFEFBC89
- Run hex2bin on this
- 姫川 かずみ（ひめかわ かずみ）
Experiment 5
- UNHEX(HEX(CONVERT(CAST(CONVERT(japanese USING latin1) AS BINARY)USING utf8)))
- 姫川 かずみ（ひめかわ かずみ）
utf8 Experiments