According to "Nicolas Vervelle" <[email protected]>: > Could you tell me the collation you are using in the Proteopedia wiki ? Is > it "utf8_unicode_ci", "utf8_bin" or some other collation ? > I will use the same on my database and it should do the trick.
Hi Nico, This is the current general mysql setup on Proteopedia, Individual tables hold not special collation nor character definitions. | character_set_client | latin1 | character_set_connection | latin1 | character_set_database | latin1 | character_set_filesystem | binary | character_set_results | latin1 | character_set_server | latin1 | character_set_system | utf8 | character_sets_dir | /usr/share/mysql/charsets/ | collation_connection | latin1_swedish_ci | collation_database | latin1_swedish_ci | collation_server | latin1_swedish_ci I understand that you're trying to migrate between character sets hoping for mysql to deal with the comparisons, hence having problems with collations. Have you tried doing the job on a scripting language (perl, php, ...) by retrieving a raw page from the source wiki, converting it in your script, and uploading the 'ported' page onto the new wiki? Jaim -- Dr Jaime Prilusky | [email protected] Head Bioinformatics | R&D Bioinformatics and Data Management | Department of Biological Services | Weizmann Institute of Science | fax: 972-8-9344113 76100 Rehovot - Israel | tel: 972-8-9344959 OCA, http://oca.weizmann.ac.il (the protein structure/function database) Proteopedia, http://proteopedia.org (because life has more than 2D) ------------------------------------------------------------------------ ------------------------------------------------------------------------------ Come build with us! The BlackBerry® Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9-12, 2009. Register now! http://p.sf.net/sfu/devconf _______________________________________________ Jmol-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jmol-users
