Editing OpenBiblio

OpenBiblioÃÂ¦ÃÂÃÂ¯[[OpenSource for Educators|ÃÂ©ÃÂÃÂÃÂ¦ÃÂÃÂ¾ÃÂ¥ÃÂÃÂÃÂ¥ÃÂ§ÃÂÃÂ§ÃÂ¢ÃÂ¼]]ÃÂ§ÃÂÃÂÃÂ¥ÃÂÃÂÃÂ¦ÃÂÃÂ¸ÃÂ§ÃÂ®ÃÂ¡ÃÂ§ÃÂÃÂÃÂ§ÃÂ³ÃÂ»ÃÂ§ÃÂµÃÂ±ÃÂ£ÃÂÃÂ

{{Software version | url=http://freshmeat.net/projects/obiblio/ | software=OpenBiblio | version=0.6.0 }}

I can't hear you very well <a href=" http://www.tiaworldwide.com/dream ">is paxil good for anxiety and depression</a>  Section 4 - General Policies And Procedures (continued)
 <a href=" http://bartleyridge.net/price/ ">serotonin syndrome paxil withdrawal</a>  excellence ability. Never ability. Rarely committed to ability. Usually ability. Always
 <a href=" http://www.cartigny.ch/index.php/environnement ">online topamax prescription</a>  FOCUS: IV Therapy PM PM PM PM
 <a href=" http://www.samora.no/musikk/gromme-kassetter ">retin a acne scars before and after</a>  A. Pathophysiology of common pathophysiology basic principles with with infrequent or depth with no

== localization ==
* copy the {openbiblio}/locale/en to {openbiblio}/locale/en_utf
* modify the {openbiblio}/locale/en_utf8/metadata.php <pre> "locale_description" => "English_utf8" </pre>

: http://farm2.static.flickr.com/1238/1167678345_7fef04238c.jpg
: image host on [http://www.flickr.com/photos/planetoid/1167678345/ flickr]


; Setup the library
* Click the ''admin'' label
* login the default admin account
* click the ''library settings''
**  Locale: switch to English_utf8
**  HTML Charset: modify iso-8859-1 to utf-8
* click the ''Update'' button


; When create DB (for MySQL5)
SQL:

  create database openbiblio CHARACTER SET utf8 COLLATE utf8_general_ci;


; Modify PHP source

openbiblio\Query.php

add line: '''$rc = Query::act( 'SET NAMES UTF8' );'''
so that all connection will be UTF8


  function connect_e() {
    list($this->_link, $e) = Query::_connect_e();   
    '''$rc = Query::act( 'SET NAMES UTF8' );'''
    return $e;
  }

; Modify PHP source (version 0.6.1)

openbiblio\classes\Query.php

add the two lines: '''mysql_query("SET CHARACTER SET utf8");''' and '''mysql_query("SET NAMES utf8");'''
so that all connection will be UTF8


  function _connect_e() {
    static $link;
    if (!isset($link)) {
      if (!function_exists('mysql_connect')) {
        return array(NULL, new DbError("Checking for MySQL Extension...",
                           "Unable to connect to database.",
                           "The MySQL extension is not available"));
      }
      $link = mysql_connect(OBIB_HOST,OBIB_USERNAME,OBIB_PWD);
      mysql_query("SET CHARACTER SET utf8");
      mysql_query("SET NAMES utf8");
      if (!$link) {
        return array(NULL, new DbError("Connecting to database server...",
                                       "Cannot connect to database server.",
                                       mysql_error()));
      }
      $rc = mysql_select_db(OBIB_DATABASE, $link);
      if (!$rc) {
        return array(NULL, new DbError("Selecting database...",
                                       "Cannot select database.",
                                       mysql_error($link)));
      }
    }
    return array($link, NULL);
  }


; Validation
* click the ''Cataloging'' label -> ''New Bibliography''
* ''add a new Bibliography'' in Chinese
* & search ''Bibliography Search'' in Chinese
* Check MySQL DB table biblio, to see if the string stored in Chinese. You can use freeware Toad for MySQL to do it.
* Try again in Simplified Chinese


;Reference
* [http://obiblio.sourceforge.net/index.php/Main/TranslatingOpenBiblio OpenBiblio | Main / TranslatingOpenBiblio browse]

discussion
* [http://sourceforge.net/p/obiblio/discussion/164978/thread/c04da600/ OpenBiblio / Discussion / Help:0.7.1 default language] 2013-06-30

[[Category:OSS]] [[Category:Education]]