[B! ã‚³ãƒ¼ãƒ‰] syuntaeharaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

syuntaehara id:syuntaehara

ã‚³ãƒ¼ãƒ‰ã«é–¢ã™ã‚‹syuntaeharaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (15)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

ãƒ†ãƒ³ã‚·ãƒ§ãƒ³ã‚³ãƒ¼ãƒ‰
å¾©éŸ³ç¨‹ ï¼‘ã‚ªã‚¯ã‚¿ãƒ¼ãƒ–ä»¥å†…ã®éŸ³ç¨‹ã‚’å˜éŸ³ç¨‹ã€ï¼‘ã‚ªã‚¯ã‚¿ãƒ¼ãƒ–ã‚ˆã‚Šä¸Šã®éŸ³ç¨‹ã‚’å¾©éŸ³ç¨‹ã¨ã„ã„ã¾ã™ã€‚ å¾©éŸ³ç¨‹ã¯ãã®åº¦æ•°ã‹ã‚‰ï¼—åº¦ã‚’å¼•ã„ãŸå˜éŸ³ç¨‹ã®éŸ³ã¨åŒã˜éŸ³ã«ãªã‚Šã¾ã™ã€‚ ï¼ˆä¾‹:ãƒ«ãƒ¼ãƒˆãŒCã®å ´åˆ11åº¦ã¯ï¼Ÿ11åº¦-ï¼—åº¦ï¼4åº¦ã€11åº¦ã¯Fã®éŸ³ï¼‰ é€šå¸¸ã®ã‚³ãƒ¼ãƒ‰ã«å¾©éŸ³ç¨‹ã‚’åŠ ãˆã¦ãƒ†ãƒ³ã‚·ãƒ§ãƒ³ã‚³ãƒ¼ãƒ‰ã‚’ä½œã‚‹ã‚ã‘ã§ã™ãŒã€ã‚³ãƒ¼ãƒ‰ãƒˆãƒ¼ãƒ³ã¨åŒã˜éŸ³ã‚’åŠ ãˆã¦ã‚‚æ„å‘³ãŒãªã„ã®ã§ã€9thã€11thã€13thãŒä½¿ãˆã‚‹ã“ã¨ã«ãªã‚Šã¾ã™ã€‚ 9thã€11thã€13thã®éŸ³ã‚’ã€Œãƒ†ãƒ³ã‚·ãƒ§ãƒ³ãƒŽãƒ¼ãƒˆã€ã¨ã„ã„ã¾ã™ã€‚ãã‚Œãžã‚Œã«åŠéŸ³ä¸Šä¸‹ã«å¤‰åŒ–ã™ã‚‹ã“ã¨ã‚‚ã‚ã‚Šã¾ã™ã€‚ï¼ˆå›³6-1ï¼‰ ä½¿ãˆã‚‹ãƒ†ãƒ³ã‚·ãƒ§ãƒ³ã®ç¨®é¡žã¯æ™‚ã¨å ´åˆã«ã‚ˆã£ã¦é•ã„ã¾ã™ã€‚ã™ã¹ã¦ã‚’èª¬æ˜Žã™ã‚‹åŠ›é‡ã‚‚ã‚¹ãƒšãƒ¼ã‚¹ã‚‚ãªã„ã®ã§ç‰¹ã«èˆˆå‘³ã®ã‚ã‚‹æ–¹ã¯JAZZç³»ã®å°‚é–€æ›¸ã‚’ãŠèªã¿ãã ã•ã„ã€‚ï¼ˆæœŸå¾…ã—ã¦ã„ãŸæ–¹ã€ã‚¹ã‚¤ãƒžã‚»ãƒ³ã€‚ï¼‰ çœç•¥ã®ãƒ«ãƒ¼ãƒ« ãƒ†ãƒ³ã‚·ãƒ§ãƒ³ãƒŽãƒ¼ãƒˆã‚’ã©ã‚“ã©ã‚“åŠ ãˆã¦ã„ãã¨ã€æ§‹æˆéŸ³ãŒï¼—ã¤ã®ã‚³ãƒ¼ãƒ‰ã‚‚è€ƒãˆã‚‰ã‚Œã‚‹ã‚ã‘ã§ã€å¼¦ãŒï¼–æœ¬ã—ã‹ãªã„ã‚®ã‚¿ãƒ¼ã®ã‚ˆ
syuntaehara 2012/01/08
ã‚³ãƒ¼ãƒ‰

music

Term

Musicology
ãƒªãƒ³ã‚¯
[4295] ãƒšãƒ¼ã‚¸ãƒ³ã‚°æ©Ÿèƒ½ã«ã¤ã„ã¦ã€ä¼æŽˆãã ã•ã„ã€‚ - PHPã®åŸºç¤Žä½“åŠ›æŽ²ç¤ºæ¿
syuntaehara 2011/08/15
PHP

ãƒšãƒ¼ã‚¸ãƒ³ã‚°

ç”»åƒ

ã‚³ãƒ¼ãƒ‰

test

photo

æ¤œç´¢
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒšãƒ¼ã‚¸ãƒ³ã‚°å‡ºåŠ›ã‚’è¡Œã†PHPã®ã‚³ãƒ¼ãƒ‰ - OKWAVE
ç°¡å˜ãªãƒšãƒ¼ã‚¸ãƒ³ã‚°æ©Ÿèƒ½ä»˜ãã§æ›¸ã„ã¦ã¿ã¾ã—ãŸã€‚ ç´°éƒ¨ã§ãªã«ã‹ã—ã‚‰ä¿®æ£ãŒå¿…è¦ã‹ã‚‚ã—ã‚Œãªã„ã®ã§ãŒã‚“ã°ã£ã¦ãã ã•ã„ã€‚ ï¼ˆè³ªå•æ–‡ã‚’è¦‹ã‚‹ã¨GETã‚’ä½¿ã†ã‚ˆã†ãªè¨˜è¿°ã§ã—ãŸãŒã“ã‚Œã¯POSTã§å‡¦ç†ã—ã¦ã¾ã™ï¼‰ æ¤œç´¢æ©Ÿèƒ½ã¨ã‹ä»˜ã‘ã¦ã¿ã‚‹ã®ã‚‚å‹‰å¼·ã«ãªã‚‹ã¨æ€ã„ã¾ã™ã‚ˆã€‚ <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <meta http-equiv="Pragma" content="No-Cashe"> <meta http-equiv="Cache-Control" content="No-Cache"> <title>ãƒªã‚¹ãƒˆ</title> <script type="text/javascript"> <!-- function changepage (page) { document.forms[
syuntaehara 2011/08/15
PHP

ã‚³ãƒ¼ãƒ‰

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

ãƒšãƒ¼ã‚¸ãƒ³ã‚°

html

SQL

mysql

score

db

å‹‰å¼·
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ•ã‚¡ã‚¯ãƒˆã‚¹ã‚¿ãƒ³ãƒ€ãƒ¼ãƒ‰ã®æ„å‘³ã¨ã—ã¦ï¼Œæœ€ã‚‚é©åˆ‡ãªã‚‚ã®ã¯ã©ã‚Œã‹
å•é¡Œ å•ï¼‘ã€€ãƒ‡ãƒ•ã‚¡ã‚¯ãƒˆã‚¹ã‚¿ãƒ³ãƒ€ãƒ¼ãƒ‰ã®æ„å‘³ã¨ã—ã¦ï¼Œæœ€ã‚‚é©åˆ‡ãªã‚‚ã®ã¯ã©ã‚Œã‹ã€‚ ã‚¢ã€€å·¥æ¥è£½å“ã«é–¢ã—ã¦ï¼Œæ—¥æœ¬å·¥æ¥è¦æ ¼ã¨ã—ã¦å®šã‚ãŸã‚‚ã® ã‚¤ã€€å·¥æ¥ã‚„ç§‘å¦æŠ€è¡“ã«é–¢ã—ã¦ï¼Œå›½éš›æ¨™æº–åŒ–æ©Ÿæ§‹ãŒå®šã‚ãŸè¦æ ¼ ã‚¦ã€€ç‰¹å®šã®ä¼æ¥ã‚„ã‚°ãƒ«ãƒ¼ãƒ—ãªã©ãŒæŽ¡ç”¨ã—ãŸä»•æ§˜ãŒåºƒãåˆ©ç”¨ã•ã‚Œã‚‹ã‚ˆã†ã«ãªã‚Šï¼Œäº‹å®Ÿä¸Šã®æ¥ç•Œæ¨™æº–ã«ãªã£ãŸã‚‚ã® ã‚¨ã€€ç‰¹å®šã®å›½ã‚„åœ°åŸŸï¼Œä¼æ¥ãªã©ã«é™ã‚‰ã‚ŒãŸåŸºæº–ã§ã¯ãªãï¼Œä¸–ç•Œä¸ã©ã“ã§ã‚‚é©ç”¨ã•ã‚Œã‚‹è¦æ ¼ è§£èª¬ã¨è§£ç” ãƒ‡ãƒ•ã‚¡ã‚¯ãƒˆã‚¹ã‚¿ãƒ³ãƒ€ãƒ¼ãƒ‰ï¼ˆde facto standardï¼‰ã¨ã¯ï¼Œä¼æ¥é–“ã®ç«¶äº‰ã‚„æ¶ˆè²»è€…ã®é¸æŠžè¡Œå‹•ãªã©ã®æ·˜æ±°ã‚’çµŒã¦ï¼Œåºƒãä¸€èˆ¬ã«åˆ©ç”¨ã•ã‚Œã‚‹ã‚ˆã†ã«ãªã£ãŸè£½å“ã‚„ä»•æ§˜ï¼ŒæŠ€è¡“ãªã©ã®ã“ã¨ã§ã™ã€‚ã„ã‚ã‚†ã‚‹ã€Œäº‹å®Ÿä¸Šã®æ¥ç•Œæ¨™æº–ã€ã®ã“ã¨ã§ã‚ã‚Šï¼Œå…¬çš„ãªæ¨™æº–åŒ–å›£ä½“ã«ã‚ˆã£ã¦è¦æ ¼åŒ–ã•ã‚ŒãŸã‚‚ã®ã¯å«ã¾ã‚Œã¾ã›ã‚“ã€‚ ãªãŠï¼Œãƒ‡ãƒ•ã‚¡ã‚¯ãƒˆã‚¹ã‚¿ãƒ³ãƒ€ãƒ¼ãƒ‰ã®å¯¾ç¾©èªžã¨ã—ã¦ãƒ‡ã‚¸ãƒ¥ãƒ¼ãƒ«ï¼ˆãƒ‡ã‚¸ãƒ¥ãƒªï¼‰ã‚¹ã‚¿ãƒ³ãƒ€ãƒ¼ãƒ‰ï¼ˆde jure standardï¼‰ãŒã‚ã‚Šã¾ã™ã€‚ã“ã‚Œã¯ï¼Œå…¬çš„ãªæ¨™æº–åŒ–å›£
syuntaehara 2011/06/02
ã‚µãƒ¼ãƒ“ã‚¹

ã‚³ãƒ¼ãƒ‰

IT

star

ITãƒ‘ã‚¹ãƒãƒ¼ãƒˆ
ãƒªãƒ³ã‚¯
zshã®ã‚¤ãƒ³ã‚¯ãƒªãƒ¡ãƒ³ã‚¿ãƒ«è£œå®ŒãŒã‚«ãƒƒã‚³ã‚¤ã‚¤ä»¶ã«ã¤ã„ã¦ - ã™ãŒãƒ–ãƒ
zsh ã§ã®ã‚³ãƒžãƒ³ãƒ‰å…¥åŠ›æ™‚ã«è£œå®Œã—ã¦ãã‚Œã‚‹ ä¾‹ãˆã°ã€ ls -l /Us ã¾ã§å…¥åŠ›ã™ã‚‹ã¨ã€ ls -l /Users ã¨è£œå®Œã—ã¦ãã‚Œã‚‹ã€‚ ã“ã‚“ãªæ„Ÿã˜ã§ã€è£œå®Œã•ã‚ŒãŸæ–‡å—ã¯ç·‘è‰²ã§è¡¨ç¤ºã•ã‚Œã‚‹ã€‚ è¤‡æ•°å€™è£œãŒå‡ºãŸå ´åˆã¯å…¥åŠ›è¡Œã®ä¸‹ã« Tab ã§è¤‡æ•°ã®å€™è£œãŒã§ã‚‹ã®ã¨åŒã˜æ„Ÿã˜ã§è¡¨ç¤ºã•ã‚Œã‚‹ã€‚ å…ƒã€… Tab ã§ã®è£œå®Œã‚’ä½¿ã£ã¦ã„ãŸã®ã ã‘ã©ã€ Tab ã§ã®è£œå®ŒãŒçµžã‚Šè¾¼ã¾ã‚Œã‚‹ã¾ã§ä½•æ–‡å—ã‹å…¥åŠ›ã—ã‚ˆã†ã¨ã—ã¦ç¶´ã‚Šã‚’é–“é•ãˆã‚‹ã¨ã„ã†ã®ãŒçµæ§‹ã‚ã£ãŸã€‚ ã—ã‹ã—ã€ã“ã‚ŒãŒã‚ã‚Œã°ã€ãã®ã‚ˆã†ãªã‚·ãƒ§ãƒ¼ã‚‚ãªã„ç¶´ã‚Šé–“é•ã„ãŒæ¸›ã‚Šãã†ãªæ°—ãŒã—ã¦ã„ã‚‹ã®ã§ã—ãŸã€‚ å°Žå…¥æ–¹æ³• Incremental completion on zsh ä¸Šè¨˜ã«è¡Œã£ã¦ zsh ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ä¿å˜ã™ã‚‹ã€‚ % mkdir -p .zsh/plugin % cd .zsh/plugin % curl -O -L http://mimosa-pudica.net/src/incr-0.
syuntaehara 2011/05/20
star

ã‚ã¨ã§

shell

zsh

blog

ã‚³ãƒ¼ãƒ‰

plugin

UI

tab
ãƒªãƒ³ã‚¯
æ—¥æœ¬èªž INSERT æ™‚ã« Warning (Code 1366): Incorrect string value: ... ãŒå‡ºã‚‹å•é¡Œ - æ¹–åº•æ¦‚å¿µ++
ã‚ã‚‹ Schema ã§ã¯å•é¡Œç„¡ã INSERT ãŒå‡ºæ¥ã‚‹ã®ã«åˆ¥ã® Schema ã§ã¯æ–‡å—åŒ–ã‘ã™ã‚‹ã¨è¨€ã†è‰¯ãè§£ã‚‰ãªã„ç¾è±¡ã«æ•°æ™‚é–“æ‚©ã¾ã•ã‚ŒãŸãŒã€ç§ã®å ´åˆã¯ character_set_database ãŒ latin1 ã®ã¾ã¾ã ã£ãŸã“ã¨ãŒåŽŸå› ã ã£ãŸã€‚ â˜… æ‚ªã„ä¾‹ > show variables like 'character\_set\_%'; +--------------------------+--------+ | character_set_client | utf8 | | character_set_connection | utf8 | | character_set_database | latin1 | | character_set_filesystem | binary | | character_set_results | utf8 | | character_se
syuntaehara 2011/05/05
mysql

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

garbledCharacter

æ–‡å—åŒ–ã‘

SQL

ã‚³ãƒ¼ãƒ‰

DB

windows

tips

database
ãƒªãƒ³ã‚¯
MySQL æ–‡å—åŒ–ã‘ã‚’é˜²ãã€æ–‡å—ã‚³ãƒ¼ãƒ‰ã®ç¢ºèªã¨è¨å®š
MySQL æ–‡å—åŒ–ã‘ã‚’é˜²ãã€æ–‡å—ã‚³ãƒ¼ãƒ‰ã®ç¢ºèªã¨è¨å®š 2007.01.15 MySQL æ–‡å—åŒ–ã‘ã‚’é˜²ããŸã‚ã«ã€æ–‡å—ã‚³ãƒ¼ãƒ‰ã®ç¢ºèªã¨è¨å®šã‚’è¡Œã†ã€‚ â– ç¾åœ¨ã®æ–‡å—ã‚³ãƒ¼ãƒ‰ã®è¨å®šã‚’èª¿ã¹ã‚‹ mysql> show variables like 'character_set%'; ã¾ãŸã¯ã€ mysql> status â– ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ–‡å—ã‚³ãƒ¼ãƒ‰è¨å®šã‚’èª¿ã¹ã‚‹ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã”ã¨ã«æ–‡å—ã‚³ãƒ¼ãƒ‰ã‚’è¨å®šã§ãã‚‹ã®ã§ã€ç¾åœ¨ã®æ–‡å—ã‚³ãƒ¼ãƒ‰ã‚’èª¿ã¹ã‚‹ã€‚ ï¼ˆãƒ†ãƒ¼ãƒ–ãƒ«ã”ã¨ã§ã¯ãªãã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã”ã¨ï¼‰ mysql> show create database ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å; æ–‡å—ã‚³ãƒ¼ãƒ‰ã‚’æŒ‡å®šã—ã¦ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½œã‚‹ã«ã¯ã€ mysql> create databaase xxxdb default character set utf8; â– ãƒ†ãƒ¼ãƒ–ãƒ«ã®æ–‡å—ã‚³ãƒ¼ãƒ‰è¨å®šã‚’èª¿ã¹ã‚‹ ãƒ†ãƒ¼ãƒ–ãƒ«ã”ã¨ã«æ–‡å—ã‚³ãƒ¼ãƒ‰ã‚’è¨å®šã§ãã‚‹ã®ã§ã€ç¾åœ¨ã®æ–‡å—ã‚³ãƒ¼ãƒ‰ã‚’èª¿ã¹ã‚‹ã€‚
syuntaehara 2011/05/05
mysql

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

garbledCharacter

æ–‡å—åŒ–ã‘

SQL

ã‚³ãƒ¼ãƒ‰

DB

windows

tips
ãƒªãƒ³ã‚¯
MySQL æ–‡å—åŒ–ã‘å•é¡Œã‚’æœ¬æ°—ã§ç›´ã™
mysql> status; -------------- mysql Ver 14.7 Distrib 4.1.20, for redhat-linux-gnu (i386) using readline 4.3 Connection id: 36 Current database: staff2006 Current user: maiha@localhost SSL: Not in use Current pager: lv Using outfile: '' Using delimiter: ; Server version: 4.1.20 Protocol version: 10 Connection: Localhost via UNIX socket Server characterset: latin1 Db characterset: latin1 Client char
syuntaehara 2011/05/05
mysql

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

garbledCharacter

æ–‡å—åŒ–ã‘

SQL

ã‚³ãƒ¼ãƒ‰

DB

windows

tips
ãƒªãƒ³ã‚¯
MSN Japan - ãƒ‹ãƒ¥ãƒ¼ã‚¹, å¤©æ°—, ãƒ¡ãƒ¼ãƒ« (Outlook, Hotmail), Bingæ¤œç´¢, Skype
MSN ã¯ãƒ‹ãƒ¥ãƒ¼ã‚¹ã€å¤©æ°—ã€ã‚¨ãƒ³ã‚¿ãƒ¡ã€ãƒžãƒãƒ¼ã€ã‚¹ãƒãƒ¼ãƒ„ã€ãƒ©ã‚¤ãƒ•ã‚¹ã‚¿ã‚¤ãƒ«ã€è‡ªå‹•è»Šãªã©ã®æœ€æ–°æƒ…å ±ã¨ã€å‹•ç”»ã€Bingæ¤œç´¢ã€ãƒ¡ãƒ¼ãƒ«ã® Outlook.com ï¼ˆæ—§ Hotmailï¼‰ã€Skypeãªã©ã‚’æä¾›ã™ã‚‹ Microsoft ãŒé‹å–¶ã™ã‚‹ãƒãƒ¼ã‚¿ãƒ«ã‚µã‚¤ãƒˆã§ã™ã€‚
syuntaehara 2011/05/05
mysql

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

garbledCharacter

æ–‡å—åŒ–ã‘

SQL

ã‚³ãƒ¼ãƒ‰

DB

windows

tips
ãƒªãƒ³ã‚¯
Windowsã®ã‚³ãƒžãƒ³ãƒ‰ãƒ—ãƒãƒ³ãƒ—ãƒˆã®æ–‡å—ã‚³ãƒ¼ãƒ‰ã‚’å¤‰ãˆã‚‹æ–¹æ³•
â–º 2018 (1) â–º 1æœˆ (1) â–º 2017 (4) â–º 6æœˆ (3) â–º 5æœˆ (1) â–º 2016 (15) â–º 12æœˆ (4) â–º 11æœˆ (1) â–º 10æœˆ (2) â–º 7æœˆ (3) â–º 6æœˆ (1) â–º 5æœˆ (3) â–º 1æœˆ (1) â–º 2015 (13) â–º 12æœˆ (1) â–º 10æœˆ (1) â–º 9æœˆ (1) â–º 6æœˆ (1) â–º 5æœˆ (1) â–º 3æœˆ (2) â–º 2æœˆ (3) â–º 1æœˆ (3) â–º 2014 (11) â–º 12æœˆ (1) â–º 9æœˆ (2) â–º 8æœˆ (2) â–º 6æœˆ (1) â–º 4æœˆ (4) â–º 2æœˆ (1) â–º 2013 (15) â–º 12æœˆ (3) â–º 11æœˆ (3) â–º 8æœˆ (2) â–º 7æœˆ (4) â–º 5æœˆ (1) â–º 4æœˆ (2) â–º 2012 (7) â–º 10æœˆ (1) â–º 7æœˆ (1) â–º 4æœˆ (3) â–º 1æœˆ (2) â–º 20
syuntaehara 2011/05/05
mysql

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

garbledCharacter

æ–‡å—åŒ–ã‘

SQL

ã‚³ãƒ¼ãƒ‰

DB

windows

tips
ãƒªãƒ³ã‚¯
MySQLã®ã‚³ãƒžãƒ³ãƒ‰ãƒ—ãƒãƒ³ãƒ—ãƒˆã§ã€UTF-8ã§å…¥ã£ã¦ã„ã‚‹æ–‡å—ã‚’ã€æ–‡å—åŒ–ã‘ã•ã›ãªã„ã§è¦‹ã‚‹ã«ã¯ã€‚ã€‚
ãŸã„ã—ãŸè©±é¡Œã§ã¯ãªã„ã®ã§ã€è‡ªåˆ†ã¸ã®ãƒ¡ãƒ¢ã£ã¦ã“ã¨ã§ã€‚ã€‚ã€‚ MySQLã§ã€UTF-8ã§å…¥ã‚ŒãŸæ–‡å—ã‚’ã€Windowsãƒ‘ã‚½ã‚³ãƒ³ã®mysqlã®ã‚³ãƒžãƒ³ãƒ‰ãƒ—ãƒãƒ³ãƒ—ãƒˆã§ã¿ã‚‹ã¨ã€æ–‡å—åŒ–ã‘ã—ã¾ã™ã€‚ ï¼ˆã“ã®ã¨ãã€MySQLã®DBè‡ªä½“ã¯ã€utf-8ã«è¨å®šã•ã‚Œã¦ã„ã¦ã€ãƒ‡ãƒ¼ã‚¿ã¯æ£å¸¸ã«å…¥ã£ã¦ã„ã‚‹ã‚‚ã®ã¨ã—ã¾ã™ï¼‰ã€‚ ãã®æ–‡å—åŒ–ã‘ã‚’ç›´ã—ã€MySQLã®ã‚³ãƒžãƒ³ãƒ‰ãƒ—ãƒãƒ³ãƒ—ãƒˆã§ã€UTF-8ã®æ–‡å—ã‚’è¦‹ã‚Œã‚‹ã‚ˆã†ã«ã™ã‚‹æ–¹æ³•ã€‚ MySQLã®ã‚³ãƒžãƒ³ãƒ‰ãƒ—ãƒãƒ³ãƒ—ãƒˆã‹ã‚‰ã€ SET NAMES SJIS; ã¨å…¥åŠ›ã—ã¦ãƒªã‚¿ãƒ¼ãƒ³ã€‚ æ¬¡ã«selectã™ã‚‹ã¨ã€ã¡ã‚ƒã‚“ã¨æ–‡å—ãŒè¦‹ã‚Œã‚‹ï¼ˆSET NAMESã¯ã€ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã®æ–‡å—ã‚³ãƒ¼ãƒ‰ã‚’æŒ‡å®šã™ã‚‹ã€‚ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆãŒSJISã¨ã„ã†ã“ã¨ã§ã€UTF-8ã®ãƒ‡ãƒ¼ã‚¿ã¯SJISã«å¤‰æ›ã—ã¦è¡¨ç¤ºã—ã¦ãã‚Œã‚‹ã¿ãŸã„ã ï¼‰
syuntaehara 2011/05/05
mysql

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

garbledCharacter

æ–‡å—åŒ–ã‘

SQL

ã‚³ãƒ¼ãƒ‰

DB
ãƒªãƒ³ã‚¯
ã‚«ãƒŽãƒã‚°: MySQLã§ã‚³ãƒžãƒ³ãƒ‰ãƒ—ãƒãƒ³ãƒ—ãƒˆã®æ—¥æœ¬èªžãŒæ–‡å—åŒ–ã‘ã™ã‚‹å•é¡Œã®æš«å®šå¯¾å¿œ
mysqlã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã§ã€ãƒžãƒ«ãƒãƒã‚¤ãƒˆã®ãƒ‡ãƒ¼ã‚¿ãŒå˜åœ¨ã™ã‚‹ã‚ˆã†ãªãƒ†ãƒ¼ãƒ–ãƒ«ã‚’SELECTã™ã‚‹ã¨æ–‡å—ã‚³ãƒ¼ãƒ‰ã®è¨å®šã«ã‚ˆã£ã¦ã¯æ–‡å—åŒ–ã‘ã‚’ã—ã¦ã—ã¾ã„ãƒ ã‚ãƒ¼!! ã£ã¦ãªã‚Šã¾ã™ã€‚ ã“ã‚Œã¯ã€ã‚³ãƒžãƒ³ãƒ‰ãƒ—ãƒãƒ³ãƒ—ãƒˆã®æ–‡å—ã‚³ãƒ¼ãƒ‰ãŒã€ŒCP932(Shift JISã‚’æ‹¡å¼µã—ãŸã‚‚ã®)ã€ã§å›ºå®šãªãŸã‚èµ·ã“ã£ã¦ã—ã¾ã†å•é¡Œã§ã€å…·ä½“çš„ã«ã¯mysqlã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã®ã‚ãƒ£ãƒ©ã‚¯ã‚¿ã‚»ãƒƒãƒˆã®è¨å®šãŒShift JISä»¥å¤–ã®è¨å®šã ã¨æ–‡å—åŒ–ã‘ã—ã¦ã—ã¾ã†ã‚ˆã†ã§ã™ã€‚ ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã®ã‚ãƒ£ãƒ©ã‚¯ã‚¿ã‚»ãƒƒãƒˆã®æ–‡å—ã‚³ãƒ¼ãƒ‰ã¯ã€ä»¥ä¸‹ã®ã‚ˆã†ã«statusã‚³ãƒžãƒ³ãƒ‰ã‚’å®Ÿè¡Œã™ã‚‹ã¨ã‚ã‹ã‚Šã¾ã™ã€‚ mysql> use test_db; Database changed mysql> status; -------------- mysql Ver 14.7 Distrib 4.1.12a, for Win32 (ia32) Connection id: 1 Current dat
syuntaehara 2011/05/05
mysql

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

garbledCharacter

æ–‡å—åŒ–ã‘

SQL

ã‚³ãƒ¼ãƒ‰

DB
ãƒªãƒ³ã‚¯
ã·ãŽãˆã‚‚ã‚“æ—¥è¨˜ |åˆã‚ã¦ã®Mysqlã¨æ–‡å—åŒ–ã‘
ã©ã‚“ãªã‚¿ã‚¤ãƒˆãƒ«ã ã‚ˆã£ã¦æ„Ÿã˜ã§ã™ãï½—ï¼Ž å…ˆæœˆMysqlã‚³ãƒžãƒ³ãƒ‰ãƒ—ãƒãƒ³ãƒ—ãƒˆã§è§¦ã£ã¦ã¿ãŸã‚‰å…¨è§’æ–‡å—ã®æ—¥æœ¬èªžãŒæ–‡å—åŒ–ã‘ã—ã¾ãã£ã¦çµæ§‹ã‚€ã‹ã¤ãã¾ã—ãŸï¼Ž æ¤œç´¢ã—ãŸã‚‰çµæ§‹ç§ã¨åŒã˜ã‚ˆã†ãªç—‡çŠ¶ãŒå‡ºã¦ã„ã‚‹äººãŒã„ã‚‹ã¿ãŸã„ã§ã—ãŸï¼Ž ãã‚Œã§ã„ã¦æ¤œç´¢ã•ã‚ŒãŸå›žç”ã¨ã‹è¦‹ã¦ã‚‚ã»ã¨ã‚“ã©è§£æ±ºã—ãªã„ã‚ã‘ã§ã™ï½—ï¼Ž æ¤œç´¢ã®ã‚„ã‚Šæ–¹ãŒæ‚ªã‹ã£ãŸã®ã‹ãªï¼Ÿï¼Ÿ ç´ äººã¯ã¿ã‚“ãªæ–‡å—åŒ–ã‘ã™ã‚‹ã‚“ã˜ã‚ƒãªã„ã‹ãªã£ã¦ã“ã¨ã§è¨˜å¿µã«æ›¸ã„ã¦ã¿ã¾ã™ï¼Ž mysqlã®è¨å®šã¯utf8ã«ã™ã‚‹ ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‰ã¯utf8ãŒãƒ–ãƒ¼ãƒ ã‚‰ã—ã„ã§ã™ï¼Žã¨ã„ã†ã„ã“ã¨ã§utf8ã«ã—ã¾ã™ï¼Ž Mysqlã¯5.1ã§è¨å®šã¯utf8ã§ã™ï¼Ž Mysqlãƒ•ã‚©ãƒ«ãƒ€å†…ã«ã‚ã‚‹my.iniã«ã¯default-character-set=utf8ã¨æ›¸ã„ã¦ã‚ã‚‹ã‹ã¨æ€ã„ã¾ã™ï¼Ž Mysqlã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ã¨ãã«utf8ã‚’é¸æŠžã—ã¦ãŠã‘ã°ã“ã†ãªã£ã¦ã„ã‚‹ã¨æ€ã„ã¾ã™ï¼Ž ã‚‚ã—utf8ä»¥å¤–ãŒã‚ã£ãŸã‚‰Mysqlã®ã‚¦ã‚£ã‚¶ãƒ¼ãƒ‰ã‹ã‚‰utf8ã‚’é¸
syuntaehara 2011/05/05
mysql

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

garbledCharacter

æ–‡å—åŒ–ã‘

SQL

ã‚³ãƒ¼ãƒ‰

DB

windows

tips
ãƒªãƒ³ã‚¯
çœŸå¤ã®æžœå®Ÿï¼ˆã‚µã‚¶ãƒ³ã‚ªãƒ¼ãƒ«ã‚¹ã‚¿ãƒ¼ã‚ºï¼‰ / ã‚³ãƒ¼ãƒ‰èœ / ã‚®ã‚¿ãƒ¼ - J-Total Music!
ã€Œåˆå¿ƒè€…å‘ã‘ç°¡å˜ã‚³ãƒ¼ãƒ‰Ver.ã€ã¯ã“ã¡ã‚‰ C / GonB / Am7 / Em7 /ã€€FM7 / C / Dm7 / G / C GonBã€€ã€€Am7 Em7 æ¶™ãŒã‚ãµã‚Œã‚‹ã€€æ‚²ã—ã„å£ç¯€ã¯ FM7 C Dm7 G èª°ã‹ã«æŠ±ã‹ã‚ŒãŸå¤¢ã‚’è¦‹ã‚‹ C GonBã€€ã€€Am7 Em7 æ³£ããŸã„æ°—æŒã¡ã¯ã€€è¨€è‘‰ã«å‡ºæ¥ãªã„ FM7 C Dm7 G C Dm7 ConE / ä»Šå¤œã‚‚å†·ãŸã„é›¨ã€€ãŒé™ã‚‹ FM7 G Em7 A7 ã“ã‚‰ãˆãã‚Œãªãã¦ã€€ãŸã‚æ¯ã°ã‹ã‚Š Dmã€€ã€€C#aug FonCã€€ã€€ConG G ä»Šã‚‚ã“ã®èƒ¸ã«ã€€å¤ã¯å·¡ã€€ ã‚‹ C CM7 å››å…æ™‚ä¸ã‚‚å¥½ãã¨è¨€ã£ã¦ Amã€€ã€€ã€€ã€€C7 å¤¢ã®ä¸ã¸é€£ã‚Œã¦è¡Œã£ã¦ FM7 E7ã€€ã€€ã€€Am7 å¿˜ã‚Œã‚‰ã‚Œãªã„ã€€Heart & Soul Dm7 Fm6 G å£°ã«ãªã‚‰ãªã„ C CM7 ç ‚ã«æ›¸ã„ãŸåå‰æ¶ˆã—ã¦ Amã€€ã€€ã€€ã€€ã€€C7 æ³¢ã¯ã©ã“ã¸å¸°ã‚‹ã®ã‹ FM7 E7 Am7 é€šã‚ŠéŽãŽè¡Œãã€€Lov
syuntaehara 2011/05/04
music

guitar

ã‚®ã‚¿ãƒ¼

ã‚³ãƒ¼ãƒ‰

tab
ãƒªãƒ³ã‚¯
ç„¡æ–™æŒè©žæ¤œç´¢ï¼ˆã‚³ãƒ¼ãƒ‰èœã¨ãƒ€ã‚¤ãƒ¤ã‚°ãƒ©ãƒ ã‚’è¡¨ç¤ºï¼ï¼‰ï¼J-Total Music
æ³¨ç›®ã‚³ãƒ¼ãƒ‰èœã€€ã€€ã€€ã€€ã€€CDç™ºå£²åŠã³é…ä¿¡é–‹å§‹æ—¥â†’ ç›¸æ€ç›¸æ„›ï¼ˆaikoï¼‰ 2024/05/08 ä¼šã„ã«è¡Œãã®ã«ï¼ˆã‚ã„ã¿ã‚‡ã‚“ï¼‰ 2024/05/01 ã¯ãªã‚€ã‘ï¼ˆRadio Happy Willowsï¼‰ 2024/04/26 æœã€æœˆé¢ã‚‚ç¬‘ã£ã¦ã„ã‚‹ï¼ˆDISH//ï¼‰ 2024/04/26 é»’ã„ãƒžãƒ³ãƒˆã¨çœŸã£èµ¤ãªãƒªãƒ³ã‚´ï¼ˆé•·æ¸•å‰›ï¼‰ 2024/04/24 ãŸã ã„ã¾ï¼ï¼ˆãƒˆãƒ¼ã‚¿ã‚¹æ¾æœ¬ï¼‰ 2024/04/24 ãƒ¯ãƒ«ãƒ„ï¼ˆå®¶å…¥ãƒ¬ã‚ªï¼‰ 2024/04/24 å–‰ä»ï¼ˆã‚¯ãƒªãƒ¼ãƒ—ãƒã‚¤ãƒ—ï¼‰ 2024/04/17 ã•ã‚ˆãƒ¼ãªã‚‰ã¾ãŸã„ã¤ã‹ï¼ï¼ˆç±³æ´¥çŽ„å¸«ï¼‰ 2024/04/08 æ—…ç«‹ã¡ã®é˜ï¼ˆ20th Centuryï¼‰ 2024/04/04 å¤±æ‹ã‚½ãƒ³ã‚°ï¼ˆå²¡å´Žä½“è‚²ï¼‰ 2024/03/27 ã‚¿ã‚¤ãƒ ãƒžã‚·ãƒ³ï¼ˆSEKAI NO OWARIï¼‰ 2024/03/05 ã‚¿ã‚¤ãƒ ãƒ‘ãƒ©ãƒ‰ãƒƒã‚¯ã‚¹ï¼ˆVaundyï¼‰ 2024/02/28 ãƒªã‚ºãƒ 64ï¼ˆã‚ã„ã¿ã‚‡ã‚“ï¼‰ 202
syuntaehara 2011/03/21
music

guitar

éŸ³æ¥½

ã‚³ãƒ¼ãƒ‰

æ¥½èœ

ã‚®ã‚¿ãƒ¼
ãƒªãƒ³ã‚¯
1