ater trying to move from latin1 to utf8 and conerting enconding using sed I ahev this error:
mysql -u root -p < wikidb.190510-4.utf8.mysql Enter password: ERROR 1062 (23000) at line 237: Duplicate entry '0-Procom_Netforce_3000' for key 2 the latin1 file instead works... looks like something gets mangled Platonides wrote: > Riccardo Veraldi wrote: > >> Hello, >> I'd need to set charset for my mediawiki 1.15.3 to latin1 instead of >> utf8 default >> >> this because I cannot convert my mysql DB to utf8. >> All tables in mysql DB are set to latin1. >> if I convert it to utf8 I have key lenghtness errors. >> >> Actually special characters are mangled in my mediawiki pages since I >> upgraded from an old mediawiki version 1.5.* >> to version 1.15.3 >> >> how can I Solve this ? >> is there a way to set latin1 charset in mediawiki 1.15.3 ? >> >> thanks >> >> Rick >> > > You can't. MediaWiki will always work with utf-8. > However, note that MediaWiki can also work with utf-8 text stored in > text fields that msysql thinks are latin1 ($wgDBmysql5 = false). > > If the key lenghts are not appropiate, change them. > http://www.mediawiki.org/wiki/Manual:Errors_and_Symptoms#Specified_key_was_too_long > > > > _______________________________________________ > MediaWiki-l mailing list > [email protected] > https://lists.wikimedia.org/mailman/listinfo/mediawiki-l > _______________________________________________ MediaWiki-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
