note 109939 modified in function.iconv by danbrown

From: Date: Tue, 04 Sep 2012 14:23:42 +0000
Subject: note 109939 modified in function.iconv by danbrown
References: 1  Groups: php.notes 
Request: Send a blank email to php-notes+get-190482@lists.php.net to get a copy of this message
This is useful for migration when u have corrupted data in db with MS office garbage (ISO-8859-1 &#60;--&#62; UTF-8)&#13;&#10;&#13;&#10;when iconv and mb_convert_encoding fails&#13;&#10;&#13;&#10;&#60;?php&#13;&#10;$find = array(&#13;&#10;&#34;€&#34;,&#34;‚&#34;,&#34;„&#34;,&#34;…&#34;,&#34;†&#34;,&#34;‡&#34;,&#34;‰&#34;,&#34;‹&#34;,&#34;‘&#34;,&#13;&#10;&#34;’&#34;,&#34;“&#34;,&#34;”&#34;,&#34;•&#34;,&#34;–&#34;,&#34;—&#34;,&#34;â„¢&#34;,&#34;›&#34;,&#34;¤&#34;,&#34;¦&#34;,&#13;&#10;&#34;§&#34;,&#34;¨&#34;,&#34;©&#34;,&#34;«&#34;,&#34;¬&#34;,&#34;­&#34;,&#34;®&#34;,&#34;—&#34;,&#34;°&#34;, &#34;±&#34;,&#34;´&#34;,&#13;&#10;&#34;µ&#34;,&#34;¶&#34;,&#34;·&#34;,&#34;¸&#34;,&#34;»&#34;,&#34;Á&#34;,&#34;Â&#34;,&#34;Ä&#34;,&#34;Ç&#34;,&#34;É&#34;,&#34;Ë&#34;,&#13;&#10;&#34;Í&#34;,&#34;ÃŽ&#34;,&#34;Ó&#34;,&#34;Ô&#34;,&#34;Ö&#34;,&#34;×&#34;,&#34;Ú&#34;,&#34;Ãœ&#34;,&#34;Ý&#34;,&#34;ß&#34;,&#34;á&#34;,&#34;â&#34;,&#13;&#10;&#34;ä&#34;,&#34;ç&#34;,&#34;é&#34;, &#34;ë&#34;,&#34;í&#34;,&#34;î&#34;,&#34;ó&#34;,&#34;ô&#34;,&#34;ö&#34;,&#34;÷&#34;,&#13;&#10;&#34;ú&#34;,&#34;ü&#34;,&#34;ý&#34;, &#34;ÄŒ&#34;,&#34;Å &#34;,&#34;Đ&#34;,&#34;Ć&#34;,&#34;Ž&#34;,&#34;č&#34;,&#34;Å¡&#34;,&#34;Ä‘&#34;,&#34;ć&#34;,&#34;ž&#34;&#13;&#10;);&#13;&#10;$replace = array(&#13;&#10;&#34;€&#34;,&#34;‚&#34;,&#34;„&#34;,&#34;…&#34;,&#34;†&#34;,&#34;‡&#34;,&#34;‰&#34;,&#34;‹&#34;,&#34;‘&#34;,&#34;’&#34;,&#34;“&#34;,&#34;”&#34;,&#34;•&#34;,&#34;–&#34;,&#34;—&#34;,&#13;&#10;&#34;™&#34;,&#34;›&#34;,&#34;¤&#34;,&#34;¦&#34;,&#34;§&#34;,&#34;¨&#34;,&#34;©&#34;,&#34;«&#34;,&#34;¬&#34;,&#34;­&#34;,&#34;®&#34;,&#34;—&#34;,&#34;°&#34;,&#13;&#10;&#34;±&#34;,&#34;´&#34;,&#34;µ&#34;,&#34;¶&#34;,&#34;·&#34;,&#34;¸&#34;,&#34;»&#34;,&#34;Á&#34;,&#34;Â&#34;,&#34;Ä&#34;,&#34;Ç&#34;,&#34;É&#34;,&#34;Ë&#34;,&#34;Í&#34;,&#34;Î&#34;,&#13;&#10;&#34;Ó&#34;,&#34;Ô&#34;,&#34;Ö&#34;,&#34;×&#34;,&#34;Ú&#34;,&#34;Ü&#34;,&#34;Ý&#34;,&#34;ß&#34;,&#34;á&#34;,&#34;â&#34;,&#34;ä&#34;,&#34;ç&#34;,&#34;é&#34;,&#13;&#10;&#34;ë&#34;,&#34;í&#34;,&#34;î&#34;,&#34;ó&#34;,&#34;ô&#34;,&#34;ö&#34;,&#34;÷&#34;,&#34;ú&#34;,&#34;ü&#34;,&#34;ý&#34;,&#13;&#10;&#34;Č&#34;,&#34;Š&#34;,&#34;Đ&#34;,&#34;Ć&#34;,&#34;Ž&#34;,&#34;č&#34;,&#34;š&#34;,&#34;đ&#34;,&#34;ć&#34;,&#34;ž&#34;&#13;&#10;);&#13;&#10;$string = str_replace($find,$replace,$string);&#13;&#10;?&#62; --was-- This is useful for migration when u have corrupted data in db with MS office garbage (ISO-8859-1 <--> UTF-8) when iconv and mb_convert_encoding fails $find = array( "€","‚","„","…","†","‡","‰","‹","‘", "’","“","”","•","–","—","â„¢","›","¤","¦", "§","¨","©","«","¬","­","®","—","°", "±","´", "µ","¶","·","¸","»","Á","Â","Ä","Ç","É","Ë", "Í","ÃŽ","Ó","Ô","Ö","×","Ú","Ãœ","Ý","ß","á","â", "ä","ç","é", "ë","í","î","ó","ô","ö","÷", "ú","ü","ý", "ÄŒ","Å ","Đ","Ć","Ž","č","Å¡","Ä‘","ć","ž" ); $replace = array( "€","‚","„","…","†","‡","‰","‹","‘","’","“","”","•","–","—", "™","›","¤","¦","§","¨","©","«","¬","­","®","—","°", "±","´","µ","¶","·","¸","»","Á","Â","Ä","Ç","É","Ë","Í","Î", "Ó","Ô","Ö","×","Ú","Ü","Ý","ß","á","â","ä","ç","é", "ë","í","î","ó","ô","ö","÷","ú","ü","ý", "Č","Š","Đ","Ć","Ž","č","š","đ","ć","ž" ); $string = str_replace($find,$replace,$string); http://php.net/manual/en/function.iconv.php

« previous php.notes (#190482) next »