Making DB Unicode - solution

  • Great tool !! (free is even better). Just some points to share with you all.

    To make entire application in unicode so that all languages will be ok, even in the DB:

    1) When create DB (for mySQL 5):

    create database openbiblio CHARACTER SET utf8 COLLATE utf8_general_ci;

    2) Modify openbiblio/Query.php

    add line: $rc = Query::act( 'SET NAMES UTF8' );

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

    3) Use admin to change library settings
    HTML Charset: modify iso-8859-1 to utf-8

    To test:
    - Input books in different languages, and try search for it.
    - Check if DB stores characters correctly. You can use freeware toad for mysql.

    I hope this can be put into future release, since utf-8 will work for almost everyone.