Auteur
gilbau
gilbau
Forum » » Version future » » passer de iso 8859-1 à utf8
Posté : 19-03-2017 15:45 
rappel j'étais en paramètre iso8859-1 dans le menu admin.php?op=MetaTagAdmin
et donc ma base de données était en interclassement latin1 (c'est la même chose que iso8859-1)
Donc 1ere chose exporter sa base telle que (la mienne fait quand même 325 MO non compressée en gz)
inserer une macro que j'ai faite dans notepad++ qui converti les caractères https://mozartsduweb.com/blog/correspondance-encodages-utf8-iso-88 59-1/
dans c:\Users\VotreNom\AppData\Roaming\Notepad++\shortcuts.xml
modifier ou inserer la macro
<NotepadPlus>
<InternalCommands />
<Macros>
<Macro name="Trim&nbs p;Trailing and save" Ctrl="no" Alt="yes" Shift="yes"&n bsp;Key="83">
<A ction type="2" message="0" wParam="42024" lParam="0" s Param="" />
<A ction type="2" message="0" wParam="41006" lParam="0" s Param="" />
</Macro>
<Macro name="conversi on iso8859-1 vers utf8" Ctrl="no" Alt="no" Shift= "no" Key="0">
<A ction type="3" message="1700" wParam="0" lParam="0" sP aram="" />
<A ction type="3" message="1601" wParam="0" lParam="0" sP aram="&eacute;" />
<A ction type="3" message="1625" wParam="0" lParam="2" sP aram="" />
<A ction type="3" message="1602" wParam="0" lParam="0" sP aram="é" />
<A ction type="3" message="1702" wParam="0" lParam="768" sParam="" />
<A ction type="3" message="1701" wParam="0" lParam="1609" ;sParam="" />
<A ction type="0" message="2178" wParam="0" lParam="0" sP aram="" />
<A ction type="3" message="1700" wParam="0" lParam="0" sP aram="" />
<A ction type="3" message="1601" wParam="0" lParam="0" sP aram="&egrave;" />
<A ction type="3" message="1625" wParam="0" lParam="2" sP aram="" />
<A ction type="3" message="1602" wParam="0" lParam="0" sP aram="è" />
<A ction type="3" message="1702" wParam="0" lParam="768" sParam="" />
<A ction type="3" message="1701" wParam="0" lParam="1609" ;sParam="" />
<A ction type="0" message="2178" wParam="0" lParam="0" sP aram="" />
<A ction type="0" message="2178" wParam="0" lParam="0" sP aram="" />
<A ction type="3" message="1700" wParam="0" lParam="0" sP aram="" />
<A ction type="3" message="1601" wParam="0" lParam="0" sP aram="&agrave;" />
<A ction type="3" message="1625" wParam="0" lParam="2" sP aram="" />
<A ction type="3" message="1602" wParam="0" lParam="0" sP aram="à" />
<A ction type="3" message="1702" wParam="0" lParam="768" sParam="" />
<A ction type="3" message="1701" wParam="0" lParam="1609" ;sParam="" />
<A ction type="0" message="2178" wParam="0" lParam="0" sP aram="" />
<A ction type="0" message="2178" wParam="0" lParam="0" sP aram="" />
<A ction type="3" message="1700" wParam="0" lParam="0" sP aram="" />
<A ction type="3" message="1601" wParam="0" lParam="0" sP aram="&iuml;" />
<A ction type="3" message="1625" wParam="0" lParam="2" sP aram="" />
<A ction type="3" message="1602" wParam="0" lParam="0" sP aram="ï" />
<A ction type="3" message="1702" wParam="0" lParam="768" sParam="" />
<A ction type="3" message="1701" wParam="0" lParam="1609" ;sParam="" />
<A ction type="0" message="2178" wParam="0" lParam="0" sP aram="" />
<A ction type="0" message="2178" wParam="0" lParam="0" sP aram="" />
<A ction type="3" message="1700" wParam="0" lParam="0" sP aram="" />
<A ction type="3" message="1601" wParam="0" lParam="0" sP aram="&ocirc;" />
<A ction type="3" message="1625" wParam="0" lParam="2" sP aram="" />
<A ction type="3" message="1602" wParam="0" lParam="0" sP aram="ô" />
<A ction type="3" message="1702" wParam="0" lParam="768" sParam="" />
<A ction type="3" message="1701" wParam="0" lParam="1609" ;sParam="" />
<A ction type="0" message="2178" wParam="0" lParam="0" sP aram="" />
<A ction type="0" message="2178" wParam="0" lParam="0" sP aram="" />
<A ction type="3" message="1700" wParam="0" lParam="0" sP aram="" />
<A ction type="3" message="1601" wParam="0" lParam="0" sP aram="&ccedil;" />
<A ction type="3" message="1625" wParam="0" lParam="2" sP aram="" />
<A ction type="3" message="1602" wParam="0" lParam="0" sP aram="ç" />
<A ction type="3" message="1702" wParam="0" lParam="768" sParam="" />
<A ction type="3" message="1701" wParam="0" lParam="1609" ;sParam="" />
<A ction type="0" message="2178" wParam="0" lParam="0" sP aram="" />
<A ction type="0" message="2178" wParam="0" lParam="0" sP aram="" />
<A ction type="3" message="1700" wParam="0" lParam="0" sP aram="" />
<A ction type="3" message="1601" wParam="0" lParam="0" sP aram="&ecirc;" />
<A ction type="3" message="1625" wParam="0" lParam="2" sP aram="" />
<A ction type="3" message="1602" wParam="0" lParam="0" sP aram="ê" />
<A ction type="3" message="1702" wParam="0" lParam="768" sParam="" />
<A ction type="3" message="1701" wParam="0" lParam="1609" ;sParam="" />
<A ction type="0" message="2178" wParam="0" lParam="0" sP aram="" />
<A ction type="0" message="2178" wParam="0" lParam="0" sP aram="" />
<A ction type="3" message="1700" wParam="0" lParam="0" sP aram="" />
<A ction type="3" message="1601" wParam="0" lParam="0" sP aram="&ugrave;" />
<A ction type="3" message="1625" wParam="0" lParam="2" sP aram="" />
<A ction type="3" message="1602" wParam="0" lParam="0" sP aram="ù" />
<A ction type="3" message="1702" wParam="0" lParam="768" sParam="" />
<A ction type="3" message="1701" wParam="0" lParam="1609" ;sParam="" />
<A ction type="0" message="2178" wParam="0" lParam="0" sP aram="" />
<A ction type="0" message="2178" wParam="0" lParam="0" sP aram="" />
<A ction type="3" message="1700" wParam="0" lParam="0" sP aram="" />
<A ction type="3" message="1601" wParam="0" lParam="0" sP aram="&aelig;" />
<A ction type="3" message="1625" wParam="0" lParam="2" sP aram="" />
<A ction type="3" message="1602" wParam="0" lParam="0" sP aram="æ" />
<A ction type="3" message="1702" wParam="0" lParam="768" sParam="" />
<A ction type="3" message="1701" wParam="0" lParam="1609" ;sParam="" />
<A ction type="0" message="2178" wParam="0" lParam="0" sP aram="" />
<A ction type="0" message="2178" wParam="0" lParam="0" sP aram="" />
<A ction type="3" message="1700" wParam="0" lParam="0" sP aram="" />
<A ction type="3" message="1601" wParam="0" lParam="0" sP aram="&oelig;" />
<A ction type="3" message="1625" wParam="0" lParam="2" sP aram="" />
<A ction type="3" message="1602" wParam="0" lParam="0" sP aram="œ" />
<A ction type="3" message="1702" wParam="0" lParam="768" sParam="" />
<A ction type="3" message="1701" wParam="0" lParam="1609" ;sParam="" />
<A ction type="0" message="2178" wParam="0" lParam="0" sP aram="" />
<A ction type="0" message="2178" wParam="0" lParam="0" sP aram="" />
<A ction type="3" message="1700" wParam="0" lParam="0" sP aram="" />
<A ction type="3" message="1601" wParam="0" lParam="0" sP aram="&euml;" />
<A ction type="3" message="1625" wParam="0" lParam="2" sP aram="" />
<A ction type="3" message="1602" wParam="0" lParam="0" sP aram="ë" />
<A ction type="3" message="1702" wParam="0" lParam="768" sParam="" />
<A ction type="3" message="1701" wParam="0" lParam="1609" ;sParam="" />
<A ction type="0" message="2178" wParam="0" lParam="0" sP aram="" />
<A ction type="0" message="2178" wParam="0" lParam="0" sP aram="" />
<A ction type="3" message="1700" wParam="0" lParam="0" sP aram="" />
<A ction type="3" message="1601" wParam="0" lParam="0" sP aram="&uuml;" />
<A ction type="3" message="1625" wParam="0" lParam="2" sP aram="" />
<A ction type="3" message="1602" wParam="0" lParam="0" sP aram="ü" />
<A ction type="3" message="1702" wParam="0" lParam="768" sParam="" />
<A ction type="3" message="1701" wParam="0" lParam="1609" ;sParam="" />
<A ction type="0" message="2178" wParam="0" lParam="0" sP aram="" />
<A ction type="0" message="2178" wParam="0" lParam="0" sP aram="" />
<A ction type="3" message="1700" wParam="0" lParam="0" sP aram="" />
<A ction type="3" message="1601" wParam="0" lParam="0" sP aram="&acirc;" />
<A ction type="3" message="1625" wParam="0" lParam="2" sP aram="" />
<A ction type="3" message="1602" wParam="0" lParam="0" sP aram="â" />
<A ction type="3" message="1702" wParam="0" lParam="768" sParam="" />
<A ction type="3" message="1701" wParam="0" lParam="1609" ;sParam="" />
<A ction type="0" message="2178" wParam="0" lParam="0" sP aram="" />
<A ction type="0" message="2178" wParam="0" lParam="0" sP aram="" />
<A ction type="3" message="1700" wParam="0" lParam="0" sP aram="" />
<A ction type="3" message="1601" wParam="0" lParam="0" sP aram="&euro;" />
<A ction type="3" message="1625" wParam="0" lParam="2" sP aram="" />
<A ction type="3" message="1602" wParam="0" lParam="0" sP aram="€" />
<A ction type="3" message="1702" wParam="0" lParam="768" sParam="" />
<A ction type="3" message="1701" wParam="0" lParam="1609" ;sParam="" />
<A ction type="0" message="2178" wParam="0" lParam="0" sP aram="" />
<A ction type="0" message="2178" wParam="0" lParam="0" sP aram="" />
<A ction type="3" message="1700" wParam="0" lParam="0" sP aram="" />
<A ction type="3" message="1601" wParam="0" lParam="0" sP aram="&copy;" />
<A ction type="3" message="1625" wParam="0" lParam="2" sP aram="" />
<A ction type="3" message="1602" wParam="0" lParam="0" sP aram="©" />
<A ction type="3" message="1702" wParam="0" lParam="768" sParam="" />
<A ction type="3" message="1701" wParam="0" lParam="1609" ;sParam="" />
<A ction type="0" message="2178" wParam="0" lParam="0" sP aram="" />
<A ction type="0" message="2178" wParam="0" lParam="0" sP aram="" />
<A ction type="3" message="1700" wParam="0" lParam="0" sP aram="" />
<A ction type="3" message="1601" wParam="0" lParam="0" sP aram="&curren;" />
<A ction type="3" message="1625" wParam="0" lParam="2" sP aram="" />
<A ction type="3" message="1602" wParam="0" lParam="0" sP aram="¤" />
<A ction type="3" message="1702" wParam="0" lParam="768" sParam="" />
<A ction type="3" message="1701" wParam="0" lParam="1609" ;sParam="" />
<A ction type="0" message="2178" wParam="0" lParam="0" sP aram="" />
<A ction type="3" message="1700" wParam="0" lParam="0" sP aram="" />
<A ction type="3" message="1601" wParam="0" lParam="0" sP aram="é" />
<A ction type="3" message="1625" wParam="0" lParam="2" sP aram="" />
<A ction type="3" message="1602" wParam="0" lParam="0" sP aram="é" />
<A ction type="3" message="1702" wParam="0" lParam="768" sParam="" />
<A ction type="3" message="1701" wParam="0" lParam="1609" ;sParam="" />
<A ction type="0" message="2178" wParam="0" lParam="0" sP aram="" />
<A ction type="3" message="1700" wParam="0" lParam="0" sP aram="" />
<A ction type="3" message="1601" wParam="0" lParam="0" sP aram="è" />
<A ction type="3" message="1625" wParam="0" lParam="2" sP aram="" />
<A ction type="3" message="1602" wParam="0" lParam="0" sP aram="è" />
<A ction type="3" message="1702" wParam="0" lParam="768" sParam="" />
<A ction type="3" message="1701" wParam="0" lParam="1609" ;sParam="" />
<A ction type="0" message="2178" wParam="0" lParam="0" sP aram="" />
<A ction type="3" message="1700" wParam="0" lParam="0" sP aram="" />
<A ction type="3" message="1601" wParam="0" lParam="0" sP aram="Ã" />
<A ction type="3" message="1625" wParam="0" lParam="2" sP aram="" />
<A ction type="3" message="1602" wParam="0" lParam="0" sP aram="à" />
<A ction type="3" message="1702" wParam="0" lParam="768" sParam="" />
<A ction type="3" message="1701" wParam="0" lParam="1609" ;sParam="" />
<A ction type="0" message="2178" wParam="0" lParam="0" sP aram="" />
<A ction type="0" message="2178" wParam="0" lParam="0" sP aram="" />
<A ction type="3" message="1700" wParam="0" lParam="0" sP aram="" />
<A ction type="3" message="1601" wParam="0" lParam="0" sP aram="à¯" />
<A ction type="3" message="1625" wParam="0" lParam="2" sP aram="" />
<A ction type="3" message="1602" wParam="0" lParam="0" sP aram="ï" />
<A ction type="3" message="1702" wParam="0" lParam="768" sParam="" />
<A ction type="3" message="1701" wParam="0" lParam="1609" ;sParam="" />
<A ction type="0" message="2178" wParam="0" lParam="0" sP aram="" />
<A ction type="0" message="2178" wParam="0" lParam="0" sP aram="" />
<A ction type="3" message="1700" wParam="0" lParam="0" sP aram="" />
<A ction type="3" message="1601" wParam="0" lParam="0" sP aram="à´" />
<A ction type="3" message="1625" wParam="0" lParam="2" sP aram="" />
<A ction type="3" message="1602" wParam="0" lParam="0" sP aram="ô" />
<A ction type="3" message="1702" wParam="0" lParam="768" sParam="" />
<A ction type="3" message="1701" wParam="0" lParam="1609" ;sParam="" />
<A ction type="0" message="2178" wParam="0" lParam="0" sP aram="" />
<A ction type="0" message="2178" wParam="0" lParam="0" sP aram="" />
<A ction type="3" message="1700" wParam="0" lParam="0" sP aram="" />
<A ction type="3" message="1601" wParam="0" lParam="0" sP aram="à§" />
<A ction type="3" message="1625" wParam="0" lParam="2" sP aram="" />
<A ction type="3" message="1602" wParam="0" lParam="0" sP aram="ç" />
<A ction type="3" message="1702" wParam="0" lParam="768" sParam="" />
<A ction type="3" message="1701" wParam="0" lParam="1609" ;sParam="" />
<A ction type="0" message="2178" wParam="0" lParam="0" sP aram="" />
<A ction type="0" message="2178" wParam="0" lParam="0" sP aram="" />
<A ction type="3" message="1700" wParam="0" lParam="0" sP aram="" />
<A ction type="3" message="1601" wParam="0" lParam="0" sP aram="àª" />
<A ction type="3" message="1625" wParam="0" lParam="2" sP aram="" />
<A ction type="3" message="1602" wParam="0" lParam="0" sP aram="ê" />
<A ction type="3" message="1702" wParam="0" lParam="768" sParam="" />
<A ction type="3" message="1701" wParam="0" lParam="1609" ;sParam="" />
<A ction type="0" message="2178" wParam="0" lParam="0" sP aram="" />
<A ction type="0" message="2178" wParam="0" lParam="0" sP aram="" />
<A ction type="3" message="1700" wParam="0" lParam="0" sP aram="" />
<A ction type="3" message="1601" wParam="0" lParam="0" sP aram="à¹" />
<A ction type="3" message="1625" wParam="0" lParam="2" sP aram="" />
<A ction type="3" message="1602" wParam="0" lParam="0" sP aram="ù" />
<A ction type="3" message="1702" wParam="0" lParam="768" sParam="" />
<A ction type="3" message="1701" wParam="0" lParam="1609" ;sParam="" />
<A ction type="0" message="2178" wParam="0" lParam="0" sP aram="" />
<A ction type="0" message="2178" wParam="0" lParam="0" sP aram="" />
<A ction type="3" message="1700" wParam="0" lParam="0" sP aram="" />
<A ction type="3" message="1601" wParam="0" lParam="0" sP aram="à¦" />
<A ction type="3" message="1625" wParam="0" lParam="2" sP aram="" />
<A ction type="3" message="1602" wParam="0" lParam="0" sP aram="æ" />
<A ction type="3" message="1702" wParam="0" lParam="768" sParam="" />
<A ction type="3" message="1701" wParam="0" lParam="1609" ;sParam="" />
<A ction type="0" message="2178" wParam="0" lParam="0" sP aram="" />
<A ction type="0" message="2178" wParam="0" lParam="0" sP aram="" />
<A ction type="0" message="2178" wParam="0" lParam="0" sP aram="" />
<A ction type="3" message="1700" wParam="0" lParam="0" sP aram="" />
<A ction type="3" message="1601" wParam="0" lParam="0" sP aram="Å“" />
<A ction type="3" message="1625" wParam="0" lParam="1" sP aram="" />
<A ction type="3" message="1602" wParam="0" lParam="0" sP aram="œ" />
<A ction type="3" message="1702" wParam="0" lParam="768" sParam="" />
<A ction type="3" message="1701" wParam="0" lParam="1609" ;sParam="" />
<A ction type="0" message="2178" wParam="0" lParam="0" sP aram="" />
<A ction type="0" message="2178" wParam="0" lParam="0" sP aram="" />
<A ction type="3" message="1700" wParam="0" lParam="0" sP aram="" />
<A ction type="3" message="1601" wParam="0" lParam="0" sP aram="à«" />
<A ction type="3" message="1625" wParam="0" lParam="1" sP aram="" />
<A ction type="3" message="1602" wParam="0" lParam="0" sP aram="ë" />
<A ction type="3" message="1702" wParam="0" lParam="768" sParam="" />
<A ction type="3" message="1701" wParam="0" lParam="1609" ;sParam="" />
<A ction type="0" message="2178" wParam="0" lParam="0" sP aram="" />
<A ction type="0" message="2178" wParam="0" lParam="0" sP aram="" />
<A ction type="3" message="1700" wParam="0" lParam="0" sP aram="" />
<A ction type="3" message="1601" wParam="0" lParam="0" sP aram="à¼" />
<A ction type="3" message="1625" wParam="0" lParam="1" sP aram="" />
<A ction type="3" message="1602" wParam="0" lParam="0" sP aram="ü" />
<A ction type="3" message="1702" wParam="0" lParam="768" sParam="" />
<A ction type="3" message="1701" wParam="0" lParam="1609" ;sParam="" />
<A ction type="0" message="2178" wParam="0" lParam="0" sP aram="" />
<A ction type="0" message="2178" wParam="0" lParam="0" sP aram="" />
<A ction type="3" message="1700" wParam="0" lParam="0" sP aram="" />
<A ction type="3" message="1601" wParam="0" lParam="0" sP aram="à¢" />
<A ction type="3" message="1625" wParam="0" lParam="1" sP aram="" />
<A ction type="3" message="1602" wParam="0" lParam="0" sP aram="â" />
<A ction type="3" message="1702" wParam="0" lParam="768" sParam="" />
<A ction type="3" message="1701" wParam="0" lParam="1609" ;sParam="" />
<A ction type="0" message="2178" wParam="0" lParam="0" sP aram="" />
<A ction type="0" message="2178" wParam="0" lParam="0" sP aram="" />
<A ction type="3" message="1700" wParam="0" lParam="0" sP aram="" />
<A ction type="3" message="1601" wParam="0" lParam="0" sP aram="€" />
<A ction type="3" message="1625" wParam="0" lParam="1" sP aram="" />
<A ction type="3" message="1602" wParam="0" lParam="0" sP aram="€" />
<A ction type="3" message="1702" wParam="0" lParam="768" sParam="" />
<A ction type="3" message="1701" wParam="0" lParam="1609" ;sParam="" />
<A ction type="0" message="2178" wParam="0" lParam="0" sP aram="" />
<A ction type="0" message="2178" wParam="0" lParam="0" sP aram="" />
<A ction type="3" message="1700" wParam="0" lParam="0" sP aram="" />
<A ction type="3" message="1601" wParam="0" lParam="0" sP aram="©" />
<A ction type="3" message="1625" wParam="0" lParam="1" sP aram="" />
<A ction type="3" message="1602" wParam="0" lParam="0" sP aram="©" />
<A ction type="3" message="1702" wParam="0" lParam="768" sParam="" />
<A ction type="3" message="1701" wParam="0" lParam="1609" ;sParam="" />
<A ction type="0" message="2178" wParam="0" lParam="0" sP aram="" />
<A ction type="0" message="2178" wParam="0" lParam="0" sP aram="" />
<A ction type="3" message="1700" wParam="0" lParam="0" sP aram="" />
<A ction type="3" message="1601" wParam="0" lParam="0" sP aram="¤" />
<A ction type="3" message="1625" wParam="0" lParam="1" sP aram="" />
<A ction type="3" message="1602" wParam="0" lParam="0" sP aram="¤" />
<A ction type="3" message="1702" wParam="0" lParam="768" sParam="" />
<A ction type="3" message="1701" wParam="0" lParam="1609" ;sParam="" />
</Macro>
</Macros>
<UserDefinedCommands>
<Command name="Launch in Firefox" Ctrl="yes" Alt="yes" Shift="yes" Key ="88">firefox "$(FULL_CURRENT_PATH)"</Command>
<Command name="Launch in IE" Ctrl="yes" Alt="yes" Shift="yes" Key="73" >iexplore "$(FULL_CURRENT_PATH)"</Command>
<Command name="Launch in Chrome" Ctrl="yes" Alt="yes" Shift="yes" Key= "82">chrome "$(FULL_CURRENT_PATH)"</Command>
<Command name="Launch in Safari" Ctrl="yes" Alt="yes" Shift="yes" Key= "65">safari "$(FULL_CURRENT_PATH)"</Command>
<Command name="Get&nb sp;php help" Ctrl="no" Alt="yes" Shift="no" Key="112"& gt;http://www.php.net/$(CURRENT_WORD)</Command>
<Command name="Wikipe dia Search" Ctrl="no" Alt="yes" Shift="no" Key="114"&g t;https://en.wikipedia.org/wiki/Special:Search?search=$(CURRENT_WORD)</Comma nd>
<Command name="Open&n bsp;file in another instance" Ctrl="no" Alt="yes" ;Shift="no" Key="117">$(NPP_FULL_FILE_PATH) $(CURRENT_WORD) - nosession -multiInst</Command>
<Command name="Send&n bsp;via Outlook" Ctrl="yes" Alt="yes" Shift="yes" Key= "79">outlook /a "$(FULL_CURRENT_PATH)"</Comma nd>
</UserDefinedCommands>
<PluginCommands />
<ScintillaKeys />
</NotepadPlus>
verifier que la macro "conversion iso8859-1 vers utf8" est bien présente dans notepad++
puis editer la base avec notepad++ qu'on aura installé sans modifier "Paramétrage" "preferences" "nouveau document" UTF8 sans Bom coché
Puis lancer la macro "conversion iso8859-1 vers utf8"
dans le fichier sql Faites un rechercher remplacer de DEFAULT CHARSET=latin1; en DEFAULT CHARSET=utf8;
sauvegarder sa base sous un nom modifié pour bien se repéré
puis dans phpmyadmin importer le nouveau fichier en mettant dans le "Jeu de caractères du fichier" non pas utf8 mais paradoxalement iso8859-1
Et pour moi ça marche comme à http://www.naturisme-france.com/forum.php
mais pour l'instant je n'ai pas mis toutes les tables car phpmyadmin plante à parti de la table "posts" qui est trop grosse
j'ai d'autres outils pour l'import de basse de données dont mysqldumper et l'interface ovh mais je ne peux pas forcer (paradoxalement) le "Jeu de caractères du fichier" en iso8859-1 au lieu de utf8
Cet article provient de NPDS REvolution 16
https://lab.grottes-et-karsts-de-chine.org/viewtopic.php?topic=26487&forum=4