Wiki 1.3 works with UNICODE!! (was Re: [Phpwiki-talk] pgsql for 1.3?)

[Carsten K. <car...@ma...>]

My Wiki 1.3 is working in postgresql with the database created in =
unicode!
!!!! but still needs some work.

You can see a screen snapshot of KOREAN text in Wiki 1.3 on my web site:

<http://homepage.mac.com/carstenklapp/phpwiki/>

No I don't speak Korean :-)


initdb -E 'UNICODE' /usr/local/pgsql/data
createdb -E 'UNICODE' wiki

psql wiki < schemas/psql.sql (instead of psql wiki -f schemas/psql.sql)


index.php
'dsn' =3D> 'pgsql://postgres@localhost/wiki',

browse.html, editpage.html, message.html:
<?php echo "<?xml version=3D'1.0' encoding=3D'UTF-8'?>\n"; ?>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3DUTF-8" =
/>

Carsten

On Saturday, December 8, 2001, at 08:42  pm, Carsten Klapp wrote:

>
> Hi,
>
> I'm trying to set up wiki 1.3 for use with pgsql. Is the DB backend =
for=20
> postgresql still in the works? I get this error when loading the home=20=

> page.
>  pgsql is running, wiki database created with the schema.
>
> lib/WikiDB/backend/PearDB.php:28: Fatal[256]: Can't connect to =
database:=20
> wikidb_backend_pgsql: fatal database error
>
> =95  DB Error: connect failed
> =95  (pgsql://postgres@localhost/wiki)
> =95
>
> Fatal error: Call to a member function on a non-object in=20
> /Library/WebServer/Documents/phpwiki-1.3/lib/ErrorManager.php on line =
191
>
> index.php:
> 'dsn' =3D> 'pgsql://postgres@localhost/wiki',
>
> MySQL doesn't seem to support UTF-8 or unicode yet. For Wiki to =
support=20
> UTF-8, non-ascii characters would have to be encoded into hex strings=20=

> before storing in the database. This might be ugly in the database but=20=

> the %hex%hex codes can be dumped straight into the html.
>
> pgSQL does support multibyte unicode characters and utf-8 encoded =
unicode.
>
> Carsten