Re: [Phpwiki-talk] 1.2.1 task list

[Steve W. <sw...@pa...>]

On Fri, 17 Aug 2001, Jeff Dairiki wrote:

> > How drastic?
>
> I've really only thought about the MySQL backend so far.
> There, columns which hold pagenames need to have the 'binary'
> attribute set (their type needs to be changed from
> 'VARCHAR(100) NOT NULL' to 'VARCHAR(100) BINARY NOT NULL'.)
> I think this can be done without necessitating a full
> dump/restore of the database.  If someone "forgot" to do
> this when they upgraded to 1.2.1, I think the worst that would
> happen is that his/her wiki would continue to have case
> insensitivity bugs.

Sounds fine... as long as it doesn't require hours of work on your part,
I'd say go ahead.

> The flat-file back-end has problems on Win32 systems, because
> the stupid filesystem is not case sensitive.  The best fix
> I can think of for that is to urlencode() the capital letters
> in the page names when forming file names.  (This would
> probably require a full dump/restore of the database when
> upgrading.)

It's so painful to support Windows systems regardless of type. I'm
inclined to say "You're on your own" if you run it on Windows... sigh. Of
course it's not fair to them. A lot of people have no choice in the
matter.

> I'm no expert on pgsql and msql --- they may not even be broken.
> If they are, I suspect they could be fixed in a manner similar
> to the mysql back-end.

I haven't set up 1.2 on pgsql in a while and I'm having problems vis. the
pgsql setup. Hopefully I'll work it out tomorrow or Sunday. Gotta go scuba
diving early tomorrow morning.

~swain

---
                  http://www.panix.com/~swain/
"Without music to decorate it, time is just a bunch of boring
production deadlines or dates by which bills must be paid."
                     -- Frank Zappa
http://pgp.document_type.org:11371/pks/lookup?op=get&search=0xF7323BAC