ƒnƒEƒc[ “]Š· Character “k –” — of WordPress Database
Ø‚èWordPress 2.2, WordPress —Í “Á’¥ ™Î —]—T ƒU user •t‚« –¾Šm —¼—¼ ƒUWordPress database character “k –” — ‹¤‚É DB_CHARSET –” DB_COLLATE values — wp-config.php èk. ‹¤‚É ‚±‚ê‚ç values ˆê’è, WordPress îˆÓ —p“r ƒU Žw–¼ database characterset (charset) –” database — (i.e. —Þ —ß of ƒU •Ö‚è, Œv”, –” •„’š of ˆêl•¨ “k) when ƒRƒlƒ`ƒJƒbƒg ƒAƒg database ‘åú.
•¹‚µ“á‚ç, — Œ»‘¶ WordPress installations ™Î are ã‚èâ ‚æ‚è ”ŒŽÝ e of WordPress ƒIƒyƒŒ[ƒVƒ‡ƒ“ƒYƒŠƒT[ƒ` not –¾Ž¦“I “k ƒAƒg Unicode UTF- ”ª‚ charset —, ƒU •s—šs database character “k is “ú ŽdŠ|‚¯ ˜Ô f’š˜b ( •s—šs ‰—‚¢‚Ä ‘å•û MySQL installation) ‹¤‚É latin1_swedish_ci —. ” –› q˜H ƒAƒg ƒoƒCƒŠƒ“ƒKƒ‹ ƒIƒyƒŒ[ƒVƒ‡ƒ“ƒYƒŠƒT[ƒ` ‘½‘ÐŒ¾Œê blog ‹¤‚É WordPress, –› ŒÜŒŽ –Ê– –â‘è ‰—‚¢‚Ä character •„†‰» when ŒäŽål blog –ðE are –n‹q — —]‚è ‘ÎŠO Œê, ƒIƒyƒŒ[ƒVƒ‡ƒ“ƒYƒŠƒT[ƒ` when –› ƒGƒNƒXƒ|[ƒg –” ƒoƒbƒNƒAƒbƒv ƒU database –” Œã attempt •t‚« re- —A“ü ƒU database ŽÌê ‹Å database ê’ê— ƒIƒyƒŒ[ƒVƒ‡ƒ“ƒYƒŠƒT[ƒ` ƒT[ƒo[ ˆ –” —Ü‚®‚Ü‚µ‚¢. ƒU •a’¥ is –¾”’, ŒäŽål WordPress –ðE ƒIƒyƒŒ[ƒVƒ‡ƒ“ƒYƒŠƒT[ƒ` ‹‹Žd îˆÓ ŠÜ—L ”p•i, Šï‰ö –” ™—Œy characters, ŽžÜ •½‚ç‚© ‘½– of ????? (–â‘è “_”), ƒŒƒ“ƒ_ƒŠƒ“ƒO ƒU WordPress database ‹¤‚É ŒäŽål ‹ê useless –” ¶ŽY‚ unreadable. (ŒÜŒŽ —R –’ by •s‰Â charset —)
‘çŒí–¡ solution •t‚« ƒU character •„†‰» –â‘è — WordPress is •Ï‚¸‚é ƒU charset ƒIƒyƒŒ[ƒVƒ‡ƒ“ƒYƒŠƒT[ƒ` database –” — •t‚« UTF- ”ª‚ ƒIƒyƒŒ[ƒVƒ‡ƒ“ƒYƒŠƒT[ƒ` Unicode. •¹‚µ“á‚ç, –› CANNOT š`‚É ƒRƒlƒNƒg •t‚« MySQL ’Ê‚¶‚Ä shell ƒIƒyƒŒ[ƒVƒ‡ƒ“ƒYƒŠƒT[ƒ` phpMyAdmin –” hoping —L‚ç‚ñŒÀ‚è ŒäŽål scripts îˆÓ “]Š· —Ç‚. ˜Ô explain by WordPress database •ÏŽš –, “]Š· character sets •K{ using ƒU ƒU MySQL ALTER ™{ —p–½. When ‰Â•Ï ƒU character sets, —L‚ç‚ñŒÀ‚è –{•¶ ( –” “¯‚¶) ƒtƒB[ƒ‹ƒY are ‰¼‘• •t‚« UTF- ”ª‚Â, •¹‚µ ™Î •ÏŽš îˆÓ ’©”Ñ Œ»‘¶ –{•¶ ˜Ô ƒU •ÏŽš expects ƒU —^Œ Ý‚é — f’š˜b, •¹‚µ WordPress ŒÜŒŽ have ”õ’~ unicode characters — ƒAƒg f’š˜b database, –” ‚±‚ÌŒ‹‰Ê, —^Œ ƒN[ƒƒ“ – up ˜Ô ”p•i ã ƒAƒg •ÏŽš!
ƒU – provides ƒAƒg —]’ö —–\ –” vague – ˜Ô ƒAƒg solution ‰—‚¢‚Ä ƒnƒEƒc[ ^‚É “]Š· WordPress MySQL database ‘åú ‚æ‚è –^ character “k •t‚« •Ï‚í‚Á‚½, usually UTF- ”ª‚Â. •¹‚µ“á‚ç, ƒU – ^‚É ì‹Æê, –Þ‚à ƒU ˆ—‰ß’ö ‹X‚µ‚¢ be ‰i‚¢. •Ï‚¸‚é, ƒU ƒXƒeƒbƒvƒX ˜AÀ •‚ are •t‚« alter –ÁX –” —L‚ç‚ä‚é –{•¶ –” —× ƒtƒB[ƒ‹ƒY — —L‚ç‚ä‚é WP ‘åú •t‚« BLOB, M alter ƒU character “k of database –” —g‹å‚Ì‰Ê‚Ä •ÏŠv ƒU BLOB ƒtƒB[ƒ‹ƒY — •t‚« –{•¶. –Ê‘Š —eˆÕ‚¢, •¹‚µ how ––’·‚ ƒCƒbƒg Ž©Ì ƒeƒCƒN •Ï‚¸‚é ‘´‚êŒÌ many ƒtƒB[ƒ‹ƒY ‰—‚¢‚Ä ‘´‚êŒÌ many ‘åú? •¹‚à, –› îˆÓ –’ •K—p ŽÃ‚Ô Œ´–{ “TŒ^ –” å ƒIƒyƒŒ[ƒVƒ‡ƒ“ƒYƒŠƒT[ƒ` values of —L‚ç‚ñŒÀ‚è ƒtƒB[ƒ‹ƒY.
andersapt has ’£‚èo‚µ ƒAƒg •ÏŽš script –¼‘O convert_to_utf8_sql_generator.txt which “Æ‚è‚Å‚É ¶¬ ƒAƒg – of SQL –¾Œ¾ –” —p–½ •K—p •t‚« —]‚·Š–³‚ “]Š· ŒäŽål WordPress database •t‚« UTF8 ‚ÉŠî‚¢‚Ä ƒU –. •¹‚µ“á‚ç, ”Þ•û ã•Ó Ý‚é ƒC’Z’² “’®Ší ‹¤‚É ƒU script, –Þ‚à ƒU œß•¨ ˆøŽæl ƒCƒbƒg ˜J–ð, where Ž„‚Ìê‡, ƒCƒbƒg š`‚É wont’ ¶¬ ƒU – of SQL —p–½ Ÿø‚Þ ‚É‚æ‚é ƒU —Ž‚¿“x “PHP ’v–½“I —Ž‚¿“x: —ˆ–K •t‚« ˆêˆõ ”\ get_results() ‰—‚¢‚Ä ƒAƒg non- – — convert.php ‰—‚¢‚Ä ˜Hü 37″. ‘\‚Ä fixed, ‚±‚ê‚Å script — Žè ’½ ‹X‚µ‚¢ —D‚É –” ‘‘ “]Š· ƒU database, ‘åú –” ƒtƒB[ƒ‹ƒY ˜M‚·‚é utf8_general_ci —.
Note: –› have tried ƒAƒEƒgUTF- ”ª‚ Database •ÏŠ·Ší [“U, •¹‚µ its’ ƒAƒg ê’ê—. ƒCƒbƒg ã•Ó ”@‚ ƒU œß•¨ •ÏŠv •t‚« character “k ’¼‚É.
– •Ï‚¸‚é WordPress Database Character “k •t‚« UTF8 (Unicode)
- ƒeƒCƒN ƒU WordPress blog offline by ƒvƒ‰ƒJ[ƒh ƒAƒg ƒAƒEƒg-of- ˜J–± ƒIƒyƒŒ[ƒVƒ‡ƒ“ƒYƒŠƒT[ƒ` • ‚¨’m‚点.
- ƒoƒbƒNƒAƒbƒv database ˆÈã —]’ö ‘債‚½, •Ê‚É is • “®‚. ” ŒäŽål’ using cPanel ƒIƒyƒŒ[ƒVƒ‡ƒ“ƒYƒŠƒT[ƒ` —]‚è §Œä”Õ, its’ –³ã •t‚« —šs ƒAƒg database ƒoƒbƒNƒAƒbƒv ‚æ‚è ƒU §Œä”Õ Ž©‘Ì, where –› ‹X‚µ‚¢ ƒŠƒXƒgƒA ƒU database — ˆêŽB instead of by SQL –¾Œ¾, — ƒU âž‘Ì of –{Ši“I ŽÌê.
- ƒ_ƒEƒ“ƒ[ƒh ƒU fixed convert_to_utf8_sql_generator.txt script –” save ƒCƒbƒg ‹¤‚É ƒAƒg PHP ”g‹y.
- ƒ‚ƒfƒBƒtƒ@ƒC ƒU script •t‚« “ü—Íü ƒU database –¼‘O ŒäŽål WordPress blog is using. ƒƒP[ƒg ˆÈ‰º –{•¶:
Tables_in_DATABASENAME
ƒU DATABASENAME — ’OF is ƒU š`‚É •¨Œ ™Î –› •K—p “®‚ —Ž’…‚ ŒäŽål WordPress database –¼‘O. ƒCƒbƒg ‚ׂ« –Ê‘Š ‚±‚ñ‚È‚É ã •ÏŠv, ‘΂µ‚Ä instance,
Tables_in_wp_mydigitallife
- ƒAƒbƒvƒ[ƒh ƒU convert_to_utf8_sql_generator.php ( ƒIƒyƒŒ[ƒVƒ‡ƒ“ƒYƒŠƒT[ƒ` –› ‹X‚µ‚¢ ƒŠƒl[ƒ •t‚« ƒAƒg ’á‚¢ –¼‘O ‚Æ‚© convert.php) •t‚« ƒU –{— –{Œ¹ WordPress installation –¼ŠÓ, where wp-config.php is –’ ƒƒP[ƒg.
- M, —ˆ–K –” ƒuƒ‰ƒEƒY ƒU script ‚æ‚è ”CˆÓ •Ò•¨ ƒuƒ‰ƒEƒU. “‚ –{, š`‚É ‰ÁŽZ convert_to_utf8_sql_generator.php ( ƒIƒyƒŒ[ƒVƒ‡ƒ“ƒYƒŠƒT[ƒ` ”CˆÓ –¼‘O –› give •t‚« ƒU script) –O‚‚Ü‚Å of ŒäŽål blog URL (i.e http:/www.mywebsite.com/convert_to_utf8_sql_generator.php) –” •ñ“¹‹@ŠÖ —ˆŒõ. ƒAƒG ––’·‚ – of SQL –¾Œ¾ îˆÓ be ¶¬ ƒIƒ“ƒWƒGƒA •Ò•¨ ‹‹Žd.
- Šm• ™Î ŒäŽål post_content –” –ðE title ƒtƒB[ƒ‹ƒY ‰—‚¢‚Ä wp_posts ™{ DOES NOT belongs •t‚« ”CˆÓ •\‘è ƒIƒyƒŒ[ƒVƒ‡ƒ“ƒYƒŠƒT[ƒ` FULLTEXT •\‘è. ‘R‚à–³‚¢‚Æ ƒU “TŒ^ of ƒU ƒtƒB[ƒ‹ƒY ŒÜŒŽ not be ‰¼‘• •t‚« BLOB ‹¤‚É –^ of ƒU ‰Óð – ŽŸ. –^ [“U, ‚Æ‚© —× –ðE •ÎŒü •t‚¯‚é •\‘è •t‚« ‚±‚ê‚ç ƒtƒB[ƒ‹ƒY. ‚±‚Ìê‡, ‰¼‚É —Ž‰º ƒU •\‘è.
—Ž‚¿“X 1170 (42000): BLOB/ –{•¶ Œ… ‘post_content’ used — ”éŒ Žw’è –³‚µ ƒAƒg ”éŒ å
—Ž‚¿“X 1283 (HY000): Œ… ‘post_content’ cannot be –ðŠ„ of FULLTEXT •\‘è
- ƒƒOƒCƒ“ •t‚« ŒäŽål ƒT[ƒo[ shell by Telnet ƒIƒyƒŒ[ƒVƒ‡ƒ“ƒYƒŠƒT[ƒ` SSH. –› ‹X‚µ‚¢ ’µ–ô –{ –ðŠ„ of using ƒ†ƒjƒbƒNƒX shell ” –› •Ê“– ˜M‚·‚é phpMyAdmin “‚ ƒU •sŒ‰ ˜J–ð, •¹‚µ –› have not tried ƒCƒbƒg. ‘´‚êŒÌ ” –› do, do ƒtƒB[ƒhƒoƒbƒN ‰—‚¢‚Ä whether ƒCƒbƒg ‹X‚µ‚¢ be done.
- ƒRƒlƒNƒg •t‚« MySQL ƒT[ƒo[ ‚æ‚è ƒU shell.
- Žñ”ö ˆÈ‰º —p–½ ‘æˆê — MySQL •q·:
—p“r DATABASENAME;
–”‚à‚â, replace DATABASENAME — ’OF •t‚« ƒU ƒAƒNƒ`ƒ…ƒAƒ‹ WordPress database –¼‘O.
- M •¡ŽÊ –” ŒÐ –}‚Ä – of SQL –¾Œ¾ ƒI[ƒg ¶¬ by ƒU •ÏŽš script, –” ŒÐ ‘èÞ} into ƒU MySQL •q·. –ÁX –” —L‚ç‚ä‚é SQL —p–½ ‚ׂ« M be ˆ—‰ß’ö –” ‘–s‰Â”\ by MySQL –ˆ‚É. –› ŒÜŒŽ •K—p •t‚« •ñ“¹‹@ŠÖ —ˆŒõ ”éŒ •Ð•t‚ ƒIƒt ––‚Ì–– –^.
- ’‹ŠÔ ‘, ƒU “¯‚¶ —Ž‚¿“x l“` ‚ÉŠÖ‚·‚é ”éŒ å ˜Ô •Ê‹L ŒÜŒŽ —z. Ž„‚Ìê‡, ƒU •ÏŽš •t‚« BLOB ƒtƒFƒCƒ‹ ‹¤‚É ‚»‚ñ‚È l“` — ˆÈ‰º ƒtƒB[ƒ‹ƒY:
wp_categories.category_nicename
wp_comments.comment_approved
wp_links.link_visible
wp_options.option_name
wp_postmeta.meta_key
wp_posts.post_status
wp_posts.post_name
wp_posts.post_type
wp_usermeta.meta_key
wp_users.user_login—L‚ç‚ñŒÀ‚è ‚±‚ê‚ç ƒtƒB[ƒ‹ƒY are Ž—‹C–³‚¢ •t‚« ŠÜ—L non- ƒAƒXƒL[ characters. –” ƒtƒB[ƒ‹ƒY ‚Æ‚© category_nicename ( •”—Þ å|åŸ) –” post_name ( –ðE å|åŸ) have been URL ƒGƒ“ƒR[ƒh (where ŒäŽål URL ‹¤‚É unsafe non-alphanumeric characters îˆÓ be replaced ‹¤‚É ƒAƒg ƒp[ƒZƒ“ƒg (%) –G‰è —µ by “ñ‚ hex Œ… –” ƒWƒAƒXƒ‰[ƒ[ ƒGƒ“ƒR[ƒh ˜Ô ƒvƒ‰ƒX (+) ’›‚µ). ƒCƒjƒVƒƒƒ‹ •„†‰» of ƒoƒCƒg •„’š –” character •ª•Š ‘΂µ‚Ä UTF- ”ª‚ is ’Òåë‚̇‚Á‚½ ‹¤‚É ƒAƒXƒL[, ‘´‚êŒÌ ’¼’¼ •ÏŽš of ‚±‚ê‚ç ƒtƒB[ƒ‹ƒY •t‚« UTF8 ‚ׂ« not ‰–… too —]’ö –â‘è.
- ƒGƒfƒBƒg ƒU wp-config.php èk •t‚¯‚é — DB_CHARSET –” DB_COLLATE ƒfƒtƒBƒjƒVƒ‡ƒ“. ‰ÁŽZ ˆÈ‰º “ñ‚ ‰È”’, preferably •t‚« ƒU •Ê‚ê of MySQL ”wŒi:
defineDB_CHARSET(’’, ‘utf8′);
defineDB_COLLATE(’’, ”);˜Ô explained —WordPress ŽÊ–{, DB_COLLATE is ¶‘¤ •n–Ré« ( ƒkƒ‹) ‚悤‚É ƒU database — îˆÓ be “Æ‚è‚Å‚É ƒAƒTƒCƒ“ by MySQL ‚ÉŠî‚¢‚Ä ƒU database character “k.
- • ƒU •\‘è –”/ ƒIƒyƒŒ[ƒVƒ‡ƒ“ƒYƒŠƒT[ƒ` FULLTEXT •\‘è been “_“HŠí, ” ”CˆÓ.
- Activate ƒU blog — into ‘nì ƒ‚[ƒh.
- Check ŒäŽål blog –]‚Þ ” –œ’[ –” —L‚ç‚ä‚é characters is okay.
- ƒfƒŠ[ƒg ƒU PHP script.
‘債‚½: –{ is ƒAƒg ‹@ŠB ƒgƒ‰ƒ“ƒXƒŒ[ƒg ‹‹Žd which is provided " ˜Ô is" –³‚µ •. ‹@ŠB–|–ó ‚©‚à‚µ‚ê‚È‚¢ “‚¢ •Ù‚¦‚é. —Ç‚¢ •t‘õ– ‰p‘ –ñŠ¼ whenever —L‚蓾‚ׂ«.
•Ê‚¯‘O –” •ª’S‹à ƒIƒyƒŒ[ƒVƒ‡ƒ“ƒYƒŠƒT[ƒ` ’¸‘Õ ‹Zp“I —Í –” —Í“Y‚¦ at ‰ä‚ª ƒfƒWƒ^ƒ‹ l¶ƒQ[ƒ ƒtƒH[ƒ‰ƒ.
—× —p•i
- WordPress Charset •„†‰» –â‘è ã ã‚èâ •t‚« e 2.2
- ƒnƒEƒc[ ƒoƒbƒNƒAƒbƒv –” ƒŠƒXƒgƒA ( —Ao“ü) MySQL Databases ŠwK—p
- Ž×‹S-00016 •K{ Character “k •ÏŽš Not –¡•û —Ž‚¿“x when —A“ü •t‚« ‘õé Database
- WordPress 2.2 •ú–Æ ‘΂µ‚Ä ‘ü ƒ_ƒEƒ“ƒ[ƒh
- ‘õé EXP-00091 —Ž‚¿“x When ƒGƒNƒXƒ|[ƒg Database
- Žg—p‹ÖŽ~ –” —Ö”Ô ƒIƒt –ðE ™ˆC ƒgƒ‰ƒbƒLƒ“ƒO — WordPress 2.6 ƒIƒyƒŒ[ƒVƒ‡ƒ“ƒYƒŠƒT[ƒ` ’¼ã
- Check –” ƒIƒvƒeƒBƒ}ƒCƒY MySQL Database “Æ‚è‚Å‚É ‹¤‚É e—F/ e—F
- ƒnƒEƒc[ ƒJƒXƒ^ƒ}ƒCƒY, ƒ‚ƒfƒBƒtƒ@ƒC ƒIƒyƒŒ[ƒVƒ‡ƒ“ƒYƒŠƒT[ƒ` •ÏŠv WordPress Database ˜A— —Ž‚¿“x ‹‹Žd
- ƒ_ƒEƒ“ƒ[ƒh WordPress 2.3 •ú–Æ ŽuŠèŽÒ ˆë (RC1) ‹¤‚É Tags —Í
- ƒnƒEƒc[ •à‚Ý•û WordPress Blog •t‚« – —Ìˆæ ƒIƒyƒŒ[ƒVƒ‡ƒ“ƒYƒŠƒT[ƒ` êŠ
‘Ÿ•¨ (RSS)
˜ZŒŽ 23rd, 2007 0427:
ƒz[ƒ…
–› have žH‚ ( — ‰ä‚ª –»—˜) ™Î ƒƒK not •ÏŠv ’¼‚É ƒU database character “k, —Ç‚¢ ”á•] ‰ä‚ª [“U –” –› îˆÓ see ™Î ‘æˆê ƒCƒbƒg îˆÓ “]Š· ŒäŽål database “ñi –” ‘èÞ} •t‚« utf8 –” —g‹å‚Ì‰Ê‚Ä ƒCƒbƒg îˆÓ ƒvƒbƒg –œ’[ ”@‚ áe •„†‰» •¹‚µ –¾”’ ‹¤‚É ƒU UTF- ”ª‚ character “k…
–› šnD “‚ –” ƒAƒg..
ALTER ™{ table_name “]Š· •T‚« CHARACTER “K “ñi
‚æ‚è •½‚ç‚© ˜ô ƒAƒg mysql •¶Í ‘΂µ‚Ä —L‚ç‚ä‚é –{•¶/ •R —̈æ, ˜Ô ˜Ô –› ‹X‚µ‚¢ see ƒU –â‘è ‚³‚ ‹¤‚É ”éŒ –” –^ •\‘è value –” ƒU BLOB —Ìˆæ “TŒ^ •ÏŠv.
‰Â•Ï –{“– ƒU •¶Í ™Î ‰ä‚ª [“U —p“r îˆÓ ’Pg•‹”C —L‚ç‚ñŒÀ‚è char •t‚« “ñi, —L‚ç‚ñŒÀ‚è varchar •t‚« varbinary, —L‚ç‚ñŒÀ‚è –{•¶ (tynitext, –{•¶, mediumtext, longtext) •t‚« his “ñi •\‹L–@ (tinyblob, blob, mediumblob, ƒƒ“ƒOƒr[ƒ`) –” —g‹å‚Ì‰Ê‚Ä •½‚ç‚© “k enum –” “k “TŒ^ ‹¤‚É ƒU — “ñi.
–› •½‚ç‚© épék ‚±‚ê‚Å žH‚ –{ — –»—˜ –” Š‚Å ƒU ’š”N of ƒU –â‘è of ‰ä‚ª [“U are ‚ÉŠÖ‚·‚é ’àŽå ƒRƒ“ƒtƒBƒOƒŒ[ƒVƒ‡ƒ“ –” —]Ž– ™Î –¾”’ –› ‹X‚µ‚¢ y•I.
BTW its ƒAƒg —D—˜ •t‚« solution –Æ‚ê‚é –â‘è of ”éŒ –” •\‘è by •½‚ç‚© ”wŒi ƒU ˜É “ñi •\‹L–@ ”J‚ë ‚æ‚è using blob ‘S‘Ì‚Å ƒU —z.
‰êŽŒ ‚æ‚è ƒƒLƒVƒR –” Ï‚Ý‚Ü‚¹‚ñ ‘΂µ‚Ä —L‚ç‚ñŒÀ‚è mistyping –â‘è.
ŽµŒŽ 11th, 2007 1600:
[...] MySQL 本身的å•é¡Œï¼Œä¾¿ä¸€çŸ¥åŠè§£åœ°åŽ»äº‚ set，çµæžœä¸€æ¨£ã€‚。。 (500:) ç›´è‡³æˆ‘è®€å®Œé€™ç¯‡æ–‡ç« ï¼Œç™¼ç¾æ˜¯ WP ç”± 2.1 å‡è‡³ 2.2.1 之後，閱讀 db çš„ script 真的變了，讀ä¸äº† SQL db [...]
ŽµŒŽ 21st, 2007 1533:
[...] ” –{ âž‘Ì, —p“r – •s—šs-character-setcharset_name= ŽæŽÌ •t‚« “Á’è ƒU character “k ƒIƒyƒŒ[ƒVƒ‡ƒ“ƒYƒŠƒT[ƒ` “]Š· ƒU database •t‚« UTF8. ’¸‘Õ —Í“Y‚¦ ƒIƒyƒŒ[ƒVƒ‡ƒ“ƒYƒŠƒT[ƒ` •ª’S‹à tips ƒIƒyƒŒ[ƒVƒ‡ƒ“ƒYƒŠƒT[ƒ` ækŒv at ‰ä‚ª ƒfƒWƒ^ƒ‹ l¶ƒQ[ƒ[...]
‹ãŒŽ 4th, 2007 1857:
[...] éŽq Schnauze. Mit etwas mehr Hartnäckigkeit bei der ‚»‚ñ‚È konnte ich U••Ï’² Ende dann doch noch eine æŽè Konvertierungsanleitung ƒtƒ@ƒCƒ“ƒ_[, éŽq auf mystische ”üp und Weise sowohl auf das fehlerhafte [“U hinweist, als auch éŽq[...]
‹ãŒŽ 16th, 2007 0204:
Why dont’ –› •½‚ç‚© •¹Ý ƒU èk ’¼‚É ‚±‚ê‚Å?
ƒCƒbƒg is áu’É ‘‚«‹L‚· •½‚ç‚© •t‚« ƒ_ƒEƒ“ƒ[ƒh ƒU èk.
‹ãŒŽ 16th, 2007 0315:
[...] •Ï‚¸‚é ‰ä‚ª database •t‚« UTF8 ‘´‚êŒÌ ‰ä‚ª blog doesnt’ – ™—Œy. ƒU [“U didnt’ ˜J–ð, •Ï‚í‚Á‚½ —p’n •K{ “Í‚¯ (how æê), ‘´‚êŒÌ –› épék up ‹¤‚É ‰ä‚ª own solution which is —L‚ç‚ñŒÀ‚è ƒU[...]
‹ãŒŽ 16th, 2007 0359:
ƒz[ƒ l‚ÌŽq, Ï‚Ý‚Ü‚¹‚ñ ‘΂µ‚Ä •s•Ö, its’ ‚悤‚É users ‹X‚µ‚¢ ‰~”Õ ”CˆÓ bugs ƒIƒ“ƒWƒGƒA script ƒIƒ“ƒWƒGƒA ƒtƒH[ƒ‰ƒ when •K—p.
‹ãŒŽ 29th, 2007 0323:
[...] ƒ‰ƒ{ƒ‰ƒgƒŠ[ƒI[ƒgƒ[ƒVƒ‡ƒ“ codificación ƒf acentos, ñ y sÃmbolos ”ä—@ que funcionara ƒrƒGƒ“ƒi[ƒŒ. ”ä—@ –â‘è recomiendo —`–] artÃculo que ƒCƒ“ƒh los pasos ”ä—@ ‰Â•Ï tu bbdd ƒAƒg codificación [...]
\ˆêŒŽ 17th, 2007 0755:
[...] –š’, siempre ä ƒAƒ‹ƒSƒ‹ que ƒ}ƒCƒNƒƒGƒŒƒNƒgƒƒjƒNƒX va ƒAƒg salir desconfigurado: los –ðE o los comentarios. ƒqƒ…[ƒ}ƒ“ƒGƒ“ƒWƒjƒAƒŠƒ“ƒO probado
\ˆêŒŽ 19th, 2007 0335:
[...] ficheiro wp-config.php e deixar ƒIƒyƒŒƒCƒeƒBƒ“ƒOƒVƒXƒeƒ valores das •Ï‚í‚ç‚Ê DB_CHARSET e DB_COLLATE ‘SŠp branco. æ‹ì solução é •ÏŠ·Ší ƒAƒg –{— ƒf dados –{“ú ”ä—@ UTF- ”ª‚Â, o que ”ä—@ mim já soa ƒAƒg[...]
\“ñŒŽ 14th, 2007 0305:
ƒz[ƒ, ƒCƒbƒg ˜J–ð ãk–§ ‰ä“á‚ç using MyPHPAdmin.
ŽÓŽ« ‘΂µ‚Ä ƒU –ñŠ¼.
“ñŒŽ 27th, 2008 0120:
Im’ using PHPmyAdmin –” Œä—— •Ï‚¸‚é ‰ä‚ª database •t‚« utf- ”ª‚Â, butPHPmA… ƒCƒ“ƒ^ƒ‰ƒvƒg ƒU ˆ—‰ß’ö ‹¤‚É ƒU ‘æˆê ƒGƒ‰[ƒƒbƒZ[ƒW ( ˜V”kS ”éŒ å ˜Ô •Ê‹L — ur –).
Is ”Þ•û ƒAƒg ‘Å‚ÂŽè ˜ô PHPmA –³Ž‹ ‰Óð •‹‚ ”Þ•û ‘åú?
Thx —\‚ß!
–í¶ 2nd, 2008 0152:
[...] ƒnƒEƒc[ “]Š· character “k –” — of wordpress database? [...]
–í¶ 19th, 2008 0332:
–› ‚ׂ« ”Žè –› ‘΂µ‚Ä ˆós –{. ã Žž•ª of ’T–K ‘΂µ‚Ä an —eˆÕ‚¢ solution, when ‰ä‚ª provider •à‚Ý•û ‰ä‚ª database •t‚« an “upgraded†‹³’d, –› was —Lˆ× ˜ù‚¤ ŒäŽål instructions –” –” ’¸‘Õ ƒU character “k •ÏŠv. –› used ƒU phpmyadmin •t‚« ‘–s‰Â”\ ƒU •„’š –” ƒfƒŠ[ƒg ƒU ‰È”’ ™Î had ‰Óð. ƒCƒbƒg ran ‘S‚ –” –› š`‚É •K—p •t‚« ƒGƒfƒBƒg ƒAƒg ˜º‚© å|åŸ ™Î had •Ï character — ‘èÞ}. Fabulous!
–í¶ 31st, 2008 1309:
[...] ƒnƒEƒc[ “]Š· Character “k –” — of WordPress Database – •Ï‚¸‚é WordPress Database Character “k •t‚« UTF8 (Unicode) — » ‰ä‚ª ƒfƒWƒ^ƒ‹ l¶ƒQ[ƒ[...]
˜ZŒŽ 19th, 2008 1219:
[...] ‹¤‚É troubleshooting ƒU Žñ”ö of not —Lˆ× ˜M‚·‚é ƒU “󂠉Ȕ’ — ƒU wp-config.php èk. Tried –{ •û–@, •¹‚µ ƒCƒbƒg didnt’ ˜J–ð. M –› ”〈 up ƒU —¹Œ© of ‰Â•Ï ƒU SQL — ƒAƒg –{•¶ ƒGƒfƒBƒ^. [...]
ŽµŒŽ 24th, 2008 1853:
Ive’ ƒAƒbƒvƒ[ƒh an æ‚è“ü‚ê‚é script •t‚« ƒU –ƒãN. ƒCƒbƒg •¿ âž‘Ì where ƒU ‘åú –” Œ… are utf8 •¹‚µ ƒU ƒXƒgƒŠƒ“ƒOƒX — are f’š˜b. –{ happens when ƒU ‘åú are ¶¬ ˜Ô utf8 •¹‚µ ƒU wp-config.php is s•û•s–¾ DB_CHARSET –” DB_COLLATE variables.