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
|
