OpenBiblio: Difference between revisions

Revision as of 11:56, 2 July 2008

OpenBiblio是開放原始碼的圖書管理系統。

v.0.6.0

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

image host on flickr

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

SQL:

 create database openbiblio CHARACTER SET utf8 COLLATE utf8_general_ci;

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;
 }

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 store in Chinese. You can use freeware Toad for MySQL to do it.
Try again in Simplified Chinese

@@ Line 16: / Line 16: @@
 : image host on [http://www.flickr.com/photos/planetoid/1167678345/ flickr]
-; setup the library
+; Setup the library
 * Click the ''admin'' label
 * login the default admin account
@@ Line 24: / Line 25: @@
 * 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;
+  }
-; validation
+; 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 store in 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]
 [[Category:OSS]] [[Category:Education]]