Re: [Jmol-users] Couldn't create translated page in Japanese

2009-09-14 Thread Nicolas Vervelle
Hi Eric,

Thanks for the information.
I know MediaWiki deals without troubles with non latin languages, the
problem is probably due to the collation used in the MySql database.
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.

The hosting company on which the Jmol wiki is asked me to migrate the wiki
from their old architecture to a new one.
The migration didn't go well (database problems) and I didn't have time last
week to chat with the support to get it fixed.
That's why the site was down, but it's now online again.

Nico

On Tue, Sep 8, 2009 at 11:36 PM, Eric Martz ema...@microbio.umass.eduwrote:

 Dear Nico,

 As you may already know, Proteopedia uses MediaWiki. It seems to
 support languages just fine. The policy on non-English is still under
 discussion (Proteopedia is primarily an English wiki), but the page on 1eve
 http://proteopedia.org/wiki/index.php/1eve

 has been translated into Spanish, Russian, and

 Chinese:
 http://proteopedia.org/wiki/index.php/1eve_%28Chinese%29

 Translation to Japanese is planned.

 Today, the Jmol wiki seems to be down. I assume this is intentional.
 Thanks for your efforts to improve it!

 -Eric


 At 9/7/09, you wrote:
 Hi Takahiro,
 
 I am currently migrating the Jmol wiki to a new hosting
 environnement, and the wiki is currently done (probably for a few days).
 
 I will see what can be done for inserting Japanese articles in the
 wiki when the migration is finished and operational.
 
 Nico
 
 2009/9/4 Kudou Takahiro
 mailto:chloropla...@hotmail.comchloropla...@hotmail.com
 
 Dear all,
 
 I tried to create a translated page of 'Internationalisation' into
 Japanese.
 But I got an error message described below:
 
 ---
 Function Query in Revision::fetchFromConds
 Returned error from MySQL 1267: Illegal mix of collations
 (latin1_bin,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation
 '=' (http://sql1.wiki.jmol.orgsql1.wiki.jmol.org)
 ---
 
 It seems to be caused by the some database settings about character
 encoding.
 
 Could you change settings to be able to use Japanese?
 
 Best regards,
 
 Takahiro Kudou.
 
 
 _
 $BL5NA!*%1!%?%$$X$N(BHotmail$B%%i!%H$O$3$A$i(B
 http://home.mobile.live.com/http://home.mobile.live.com/
 
 
 

 --
 Let Crystal Reports handle the reporting - Free Crystal Reports 2008
 30-Day
 trial. Simplify your report design, integration and deployment - and focus
 on
 what you do best, core application coding. Discover what's new with
 Crystal Reports now.
 http://p.sf.net/sfu/bobj-julyhttp://p.sf.net/sfu/bobj-july
 ___
 Jmol-users mailing list
 mailto:Jmol-users@lists.sourceforge.netJmol-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/jmol-users
 
 

 --
 Let Crystal Reports handle the reporting - Free Crystal Reports 2008
 30-Day
 trial. Simplify your report design, integration and deployment - and focus
 on
 what you do best, core application coding. Discover what's new with
 Crystal Reports now.  http://p.sf.net/sfu/bobj-july
 ___
 Jmol-users mailing list
 Jmol-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/jmol-users

 /* - - - - - - - - - - - - - - - - - - - - - - - - - - -
 Eric Martz, Professor Emeritus, Dept Microbiology
 U Mass, Amherst -- http://Martz.MolviZ.Org

 Top Five 3D MolVis Technologies http://Top5.MolviZ.Org
 3D Wiki with Scene-Authoring Tools http://Proteopedia.Org
 Biochem 3D Education Resources http://MolviZ.org
 See 3D Molecules, Install Nothing! - http://firstglance.jmol.org
 ConSurf - Find Conserved Patches in Proteins: http://consurf.tau.ac.il
 Atlas of Macromolecules: http://atlas.molviz.org
 Workshops: http://workshops.molviz.org
 World Index of Molecular Visualization Resources: http://molvisindex.org
 PDB Lite Macromolecule Finder: http://pdblite.org
 Molecular Visualization EMail List (molvis-list): http://list.molviz.org
 Protein Explorer - 3D Visualization: http://proteinexplorer.org
 - - - - - - - - - - - - - - - - - - - - - - - - - - - */



 --
 Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
 trial. Simplify your report design, integration and deployment - and focus
 on
 what you do best, core application coding. Discover what's new with
 Crystal Reports now.  http://p.sf.net/sfu/bobj-july
 ___
 Jmol-users mailing list
 Jmol-users@lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/jmol-users


Re: [Jmol-users] Couldn't create translated page in Japanese

2009-09-14 Thread jaime . prilusky
According to Nicolas Vervelle nverve...@gmail.com:
 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  | jaime.prilu...@weizmann.ac.il
 Head Bioinformatics|
 RD 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 BlackBerryreg; 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#45;12, 2009. Register now#33;
http://p.sf.net/sfu/devconf
___
Jmol-users mailing list
Jmol-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jmol-users