UTF8 Support

Aus Limbas Wiki

Wechseln zu: Navigation, Suche
Diese Seite ist eine übersetzte Version der Seite UTF8 Unterstützung und die Übersetzung ist zu 100 % abgeschlossen sowie aktuell.

<-- backt to Main Page

UTF8 support is not yet completely tested and is still in a beta state.

The generation of PDF reports out of data that is saved in UTF8 will be possible in near future.


In order to use UTF-8 you must pay attention to the following during the installation of LIMBAS (where appropriate differing to the standard installation):

  • The database must get created with UTF8 encoding.
  • If PostgreSQL is used:
user "postgres":
$ psql
psql (8.4.2)
Enter >>help<< for help

postgres=# create user <limbasuser> password '<limbasuserPW>';

postgres=# create database <limbasDButf8> WITH ENCODING 'UTF8' OWNER <limbasuser> TEMPLATE template0;


$ createlang plpgsql <limbasDButf8>

$ psql -l

                                List of Databases
     Name      | Owner | Encoding | Collation | Character Type  | Access Rigjts
<limbasDButf8> |<limbasuser>| UTF8      | C            | C           |
 postgres      | postgres   | SQL_ASCII | C            | C           |
 template0     | postgres   | SQL_ASCII | C            | C           | =c/postgres
                                                                     : postgres=CTc/postgres
 template1     | postgres   | SQL_ASCII | C            | C           | =c/postgres
                                                                     : postgres=CTc/postgres
(4 Zeilen)

$ createlang -l <limbasDButf8>
Procedural Languages
  Name   | Familiar?
 plpgsql | yes
  • In order to create the LIMBAS database structure the following points must be done or set:
  • In the LIMBAS installation mask set the option "charset" to "UTF-8" .
  • DB export files must be in UTF-8 format.
The DB export files ./dependent/BACKUP/clean.tar.gz and './dependent/BACKUP/demo.tar.gz, that are included in the download must be in ISO-8859-1 format. In order to use one of these files
  • it must be unpacked : tar xvfz <DateinameISO>
  • all unpacked files must be converted to UTF-8. To do this for example "iconv" can be used (iconv --from-code=ISO-8859-1 --to-code=UTF-8 <fileISO> > <fileUTF8>)
  • all converted files must be packed again: tar cvfz <filenameUTF8>
  • The PHP module mbstring must be installed, but the mbstring.func_overload property in php.ini must not be set! Either comment out or set to 0. LIMBAS itself will replace the string functions to ensure compatibility with external frameworks.
  • Have a look at the UTF-8 difficulty

Environment Variables

The LIMBAS environment variable "charset" must be set manually to "UTF-8" if necessary.