[B! sql] thefool0613ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

thefool0613 id:thefool0613

sqlã«é–¢ã™ã‚‹thefool0613ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (4)

${{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}}

Movabletypeã®æ³¢ãƒ€ãƒƒã‚·ãƒ¥å•é¡Œã®è¦šæ›¸ - voice
ã“ã®æŠ•ç¨¿ã¯å®Œå…¨ã«å€‹äººçš„ãªè¦šæ›¸ã§ã™ã€‚ ã“ã®ä½œæ¥ã«ã‚ˆã‚Šç”Ÿã˜ãŸã‚ã‚‰ã‚†ã‚‹éšœå®³ã«é–¢ã—ã¦è²¬ä»»ã‚’è² ã„ã¾ã›ã‚“ã€‚ ã¾ãŸã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ç·¨é›†ã™ã‚‹ã®ã§æœ€æ‚ªã®å ´åˆå‹•ä½œã—ãªããªã‚‹æã‚ŒãŒã‚ã‚Šã¾ã™ã€‚ ç·¨é›†ä½œæ¥ã¯è‡ªå·±è²¬ä»»ã®ä¸‹ã§ãŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚ æ³¢ãƒ€ãƒƒã‚·ãƒ¥ ã¨ãƒãƒ«ãƒ€ã¨ã„ã†ã®ã¯ã€ä¸‹ã®ã‚ˆã†ãªã€Œã«ã‚‡ã‚ã€ã®ã“ã¨ã§ã™ã€‚ Windowsãƒ¦ãƒ¼ã‚¶ãƒ¼ã«ã¨ã£ã¦ã¯ã€ã€Œãƒãƒ«ãƒ€ã€ãŒãŠé¦´æŸ“ã¿ã§ã™ã‚ˆãã€‚ ã€Œã‹ã‚‰ã€ã¨ã‹ã€Œã«ã‚‡ã‚ã€ã§å¤‰æ›ã™ã‚‹ã¨è¡¨ç¤ºã•ã‚Œã‚‹ã®ãŒã“ã®ãƒãƒ«ãƒ€ã§ã™ã€‚ åƒ•ã‚‚ã‚ˆãä½¿ã†ã®ã§ã™ãŒã€ã“ã®ã€Œãƒãƒ«ãƒ€ã€ã¯WindowsãŒé©å½“ã«ã‚³ãƒ¼ãƒ‰ã‚’ å‰²ã‚Šå½“ã¦ã¦ã„ã‚‹ã‚‰ã—ãã€ãƒ–ãƒã‚°ãªã©ã§ã¯æ–‡å—åŒ–ã‘ã™ã‚‹ã®ã§ã™ã€‚ ã¤ã¾ã‚Šã€ã€Œï½žã€ã¨å…¥ã‚ŒãŸã®ã«ã€Œ?ã€ã§è¡¨ç¤ºã•ã‚ŒãŸã‚Šã¨ã‹ã€‚ æ³¢ãƒ€ãƒƒã‚·ãƒ¥ãªã‚‰æ–‡å—åŒ–ã‘ã¯ãªã„ã‘ã‚Œã©ã€Windowsã§æ³¢ãƒ€ãƒƒã‚·ãƒ¥ã‚’ å…¥åŠ›ã™ã‚‹ã®ã¯ã‹ãªã‚Šé¢å€’ã€‚ ã“ã®ã‚ãŸã‚Šã‚¦ã‚£ã‚ã‚’èªã‚€ã¨åˆ†ã‹ã‚‹ã‹ã‚‚ã€‚ ã§ã€kwendaã®ã‚µã‚¤ãƒˆã‚‚ã€ã“ã®å•é¡ŒãŒç”Ÿã˜ã¾ã—ãŸã€‚ ãƒãƒƒãƒˆã§ããã£ã¦ã¿ãŸã®ã§
thefool0613 2010/10/14
movabletype

langue

sql

repair

phpmyadmin

tips

japanese

entry

mojibake

utf-8
ãƒªãƒ³ã‚¯
Movable Type ã§ã€Œï½žã€ãŒã€Œ?ã€ã«æ–‡å—åŒ–ã‘ã™ã‚‹äº‹è±¡ã‚„æ—¥æœ¬èªžã®ã‚¿ã‚°ãŒåˆç®—ã§ããªã„ä¸å…·åˆã‚’è§£æ¶ˆã™ã‚‹
Movable Type ã§ MySQL 5ã‚’åˆ©ç”¨ã—ã¦ã„ã‚‹éš›ã«ã€ ãƒ–ãƒã‚°æœ¬æ–‡ãªã©ã«å«ã¾ã‚Œã‚‹ã€Œï½žã€ã¨ã„ã†æ–‡å—ãªã©ãŒã€Œ?ã€ã«æ–‡å—åŒ–ã‘ã™ã‚‹ æ—¥æœ¬èªžã®ã‚¿ã‚°ãŒåˆç®—ã§ããªã„ï¼ˆAãƒ–ãƒã‚°è¨˜äº‹ã¨Bãƒ–ãƒã‚°è¨˜äº‹ã«åŒã˜æ—¥æœ¬èªžã®ã‚¿ã‚°ã‚’ä»˜ä¸Žã—ãŸå ´åˆã€ã‚¿ã‚°ä¸€è¦§ãªã©ã§2ä»¶ã¨ãªã‚‰ãšã€ãã‚Œãžã‚Œ1ä»¶ã¨ã—ã¦è¡¨ç¤ºã•ã‚Œã‚‹ï¼‰ ã¨ã„ã£ãŸä¸å…·åˆã‚’è§£æ¶ˆã™ã‚‹æ–¹æ³•ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ ã™ã§ã«å¤šãã®ã‚µã‚¤ãƒˆã§ç´¹ä»‹ã•ã‚Œã¦ã„ã‚‹ã®ã§ç›®æ–°ã—ã„æƒ…å ±ã§ã¯ã‚ã‚Šã¾ã›ã‚“ãŒã¨ã‚Šã‚ãˆãšã€‚ ï¼‘ï¼ŽåŽŸå› ã‚¿ã‚¤ãƒˆãƒ«ã®ä¸å…·åˆãŒç”Ÿã˜ã‚‹åŽŸå› ã¯ã€å¯¾è±¡ãƒ†ãƒ¼ãƒ–ãƒ«ã®ã‚«ãƒ©ãƒ ã®ç…§åˆé †åºãŒã€Œujis_japanese_ciã€ã«ãªã£ã¦ã„ã‚‹ãŸã‚ã®ã‚ˆã†ã§ã™ã€‚ã“ã®ç…§åˆé †åºã‚’ã€Œutf8_general_ciã€ã«ã™ã‚‹ã“ã¨ã§è§£æ¶ˆã—ã¦ã„ã‚‹ã‚ˆã†ã§ã™ã€‚ ã¡ãªã¿ã«ã€ã€Œç…§åˆé †åºã€ã¨ã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‹ã‚‰ select ã™ã‚‹éš›ã®ãƒ«ãƒ¼ãƒ«ã‚’ç¤ºã™ã‚‚ã®ã®ã‚ˆã†ã§ã€ ujis/utf8ï¼šæ–‡å—ã‚³ãƒ¼ãƒ‰ japanese/generalï¼šç…§åˆå½¢å¼ c
thefool0613 2010/10/14
movabletype

langue

sql

repair

phpmyadmin

tips

japanese

entry

mojibake

utf-8
ãƒªãƒ³ã‚¯
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
thefool0613 2009/07/31
database

linux

mysql

sql

tips

utf-8

æ–‡å—ã‚³ãƒ¼ãƒ‰

æ–‡å—åŒ–ã‘

converter

latin1
ãƒªãƒ³ã‚¯
GUIç®¡ç†ãƒ„ãƒ¼ãƒ«ã®å°Žå…¥ã¨ãƒ¦ãƒ¼ã‚¶ãƒ¼æƒ…å ±ã®SQLåŒ–
qmailadminã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã¨ã‚«ã‚¹ã‚¿ãƒžã‚¤ã‚º qmailadminã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã‚’å§‹ã‚ã‚‹å‰ã«ã€æ¬¡ã®ã‚‚ã®ãŒä½¿ç”¨å¯èƒ½ã«ãªã£ã¦ã„ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ã€Œautoresponderã€ã¯ã¾ã ç´¹ä»‹ã—ã¦ã„ã¾ã›ã‚“ãŒã€ãã‚Œä»¥å¤–ã¯ãƒªãƒ³ã‚¯ã—ãŸå„è¨˜äº‹ã‚’å‚è€ƒã«ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¦ãŠãã¾ã™ã€‚
thefool0613 2008/08/01
qmailadminã®è¨å®š

server

qmail

qmailadmin

sql

mail

è¨å®š
ãƒªãƒ³ã‚¯
1

ãŠçŸ¥ã‚‰ã›

ã‚‚ã£ã¨èªã‚€

å…¬å¼Twitter

@hatebu
æœ€æ–°ã®äººæ°—ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã®é…ä¿¡

ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

jæ¬¡ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

kå‰ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

lã‚ã¨ã§èªã‚€

eã‚³ãƒ¡ãƒ³ãƒˆä¸€è¦§ã‚’é–‹ã

oãƒšãƒ¼ã‚¸ã‚’é–‹ã

è¨å®šã‚’å¤‰æ›´ã—ã¾ã—ãŸx

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

ã‚¿ã‚°

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (21)

sqlã«é–¢ã™ã‚‹thefool0613ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (4)

ãŠçŸ¥ã‚‰ã›

æœˆé–“ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2025å¹´2æœˆï¼‰

æ—§ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®Chromeæ‹¡å¼µæ©Ÿèƒ½ã«ã¤ã„ã¦ã®ãŠçŸ¥ã‚‰ã›ã¨æ–°ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã”åˆ©ç”¨ã®ãŠé¡˜ã„

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2025å¹´3æœˆç¬¬1é€±ï¼‰

å…¬å¼Twitter

ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹

ã‚¿ã‚°

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (21)

sqlã«é–¢ã™ã‚‹thefool0613ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (4)

Movabletypeã®æ³¢ãƒ€ãƒƒã‚·ãƒ¥å•é¡Œã®è¦šæ›¸ - voice

Movable Type ã§ã€Œï½žã€ãŒã€Œ?ã€ã«æ–‡å­—åŒ–ã‘ã™ã‚‹äº‹è±¡ã‚„æ—¥æœ¬èªžã®ã‚¿ã‚°ãŒåˆç®—ã§ããªã„ä¸å…·åˆã‚’è§£æ¶ˆã™ã‚‹

MySQL æ–‡å­—åŒ–ã‘å•é¡Œã‚’æœ¬æ°—ã§ç›´ã™

GUIç®¡ç†ãƒ„ãƒ¼ãƒ«ã®å°Žå…¥ã¨ãƒ¦ãƒ¼ã‚¶ãƒ¼æƒ…å ±ã®SQLåŒ–

ãŠçŸ¥ã‚‰ã›

æœˆé–“ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚­ãƒ³ã‚°ï¼ˆ2025å¹´2æœˆï¼‰

æ—§ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®Chromeæ‹¡å¼µæ©Ÿèƒ½ã«ã¤ã„ã¦ã®ãŠçŸ¥ã‚‰ã›ã¨æ–°ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã”åˆ©ç”¨ã®ãŠé¡˜ã„

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚­ãƒ³ã‚°ï¼ˆ2025å¹´3æœˆç¬¬1é€±ï¼‰

å…¬å¼Twitter

ã‚­ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (21)

sqlã«é–¢ã™ã‚‹thefool0613ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (4)

Movabletypeã®æ³¢ãƒ€ãƒƒã‚·ãƒ¥å•é¡Œã®è¦šæ›¸ - voice

Movable Type ã§ã€Œï½žã€ãŒã€Œ?ã€ã«æ–‡å—åŒ–ã‘ã™ã‚‹äº‹è±¡ã‚„æ—¥æœ¬èªžã®ã‚¿ã‚°ãŒåˆç®—ã§ããªã„ä¸å…·åˆã‚’è§£æ¶ˆã™ã‚‹

MySQL æ–‡å—åŒ–ã‘å•é¡Œã‚’æœ¬æ°—ã§ç›´ã™

GUIç®¡ç†ãƒ„ãƒ¼ãƒ«ã®å°Žå…¥ã¨ãƒ¦ãƒ¼ã‚¶ãƒ¼æƒ…å ±ã®SQLåŒ–

ãŠçŸ¥ã‚‰ã›

æœˆé–“ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2025å¹´2æœˆï¼‰

æ—§ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®Chromeæ‹¡å¼µæ©Ÿèƒ½ã«ã¤ã„ã¦ã®ãŠçŸ¥ã‚‰ã›ã¨æ–°ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã”åˆ©ç”¨ã®ãŠé¡˜ã„

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2025å¹´3æœˆç¬¬1é€±ï¼‰

å…¬å¼Twitter

ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹