From: Reini U. <ru...@x-...> - 2005-03-10 06:54:19
|
[please post to the mailinglist] Bruno Browning schrieb: > I tried to install phpwiki from CVS this morning (we use v1.2 quite a > bit and are very interested in UTF-8 in our wikis). We want to use it > with Postgresql (currently 7.4.6), and I thought I should let you know > that in order to get that to work I had to: Be sure to look at my older utf-8 patch also, at the sf.net sites under patches. This adds utf8 support to most string functions, mostly pcre_... so far. Our japanese translator reported problems with certain pagesnames in utf-8 with the current version. > 1) patch the psql-initialize script. > > diff psql-initialize.sql.patched psql-initialize.sql > 67d66 > < \set rating_id :prefix 'rating_id' > 150,152c149,151 > < dimension NUMERIC(4) NOT NULL, > < raterpage NUMERIC(11) NOT NULL, > < rateepage NUMERIC(11) NOT NULL, > --- > >> dimension NUMBER(4) NOT NULL, >> raterpage NUMBER(11) NOT NULL, >> rateepage NUMBER(11) NOT NULL, > > 154c153 > < rateeversion NUMERIC(11) NOT NULL, > --- > >> rateeversion NUMBER(11) NOT NULL, > > 164c163 > < time_stamp INT, > --- > >> time_stamp INT UNSIGNED, > > 173,174c172,173 > < status SMALLINT, > < bytes_sent SMALLINT, > --- > >> status SMALLINT UNSIGNED, >> bytes_sent SMALLINT UNSIGNED, > > > 2) Remove the MySQLism 'DELAYED' on line 1117 of lib/Request.php oops. thanks. > We are using pubcookie to authenticate people against a campus database, > and thus really need HttpAuth (which works really well in v1.2). That > doesn't seem to be working at the moment, so I'm going to have to back > off for a bit. Will try to find time to look at HttpAuth and see if > there's anything I can do to help. yes, please. dan frankowski also had an earlier httpauth patch in the patch section, but there's a bit more work todo for full httpauth. -- Reini Urban http://xarch.tu-graz.ac.at/home/rurban http://phpwiki.org |