14,957
edits
OpenBiblio: Difference between revisions
Jump to navigation
Jump to search
m
Text replacement - "in Chinese" to "in Mandarin Chinese"
No edit summary |
m (Text replacement - "in Chinese" to "in Mandarin Chinese") |
||
| (19 intermediate revisions by 6 users not shown) | |||
| Line 7: | Line 7: | ||
* Setup the MySQL: {openbiblio}/database_constants.php | * Setup the MySQL: {openbiblio}/database_constants.php | ||
: more on [http://www.iriti.cnr.it/openbiblio/install_instructions.html OpenBiblio Install Instructions] | : more on [http://www.iriti.cnr.it/openbiblio/install_instructions.html OpenBiblio Install Instructions] | ||
* run the http://localhost/openbiblio/install/index.php | * run the <nowiki>http://localhost/openbiblio/install/index.php</nowiki> | ||
== localization == | == localization == | ||
| Line 16: | Line 16: | ||
: image host on [http://www.flickr.com/photos/planetoid/1167678345/ flickr] | : image host on [http://www.flickr.com/photos/planetoid/1167678345/ flickr] | ||
; | |||
; Setup the library | |||
* Click the ''admin'' label | * Click the ''admin'' label | ||
* login the default admin account | * login the default admin account | ||
| Line 24: | Line 25: | ||
* click the ''Update'' button | * 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'' | * click the ''Cataloging'' label -> ''New Bibliography'' | ||
* ''add a new Bibliography'' in Chinese | * ''add a new Bibliography'' in Mandarin Chinese | ||
* & search ''Bibliography Search'' in Chinese | * & search ''Bibliography Search'' in Mandarin Chinese | ||
* Check MySQL DB table biblio, to see if the string stored in Mandarin Chinese. You can use freeware Toad for MySQL to do it. | |||
* Try again in Simplified Chinese | |||
Reference | ;Reference | ||
* [http://obiblio.sourceforge.net/index.php/Main/TranslatingOpenBiblio OpenBiblio | Main / TranslatingOpenBiblio browse] | * [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]] | [[Category:OSS]] [[Category:Education]] | ||