Re: [Phpwiki-talk] 1.2.1 task list

[Jeff D. <da...@da...>]

On Aug 17, 2001, Steve Wainstead said:
> 
> In two weeks I will be back in Manhattan, where my other Linux box is with
> msql... I will test it then. (Don't feel like installing it yet again and
> recompiling && etc.)
> 

That's fine.

> > I would still like to fix the page name case-sensitivity issues, but
> > would first like to hear from Steve and others how kosher you think
> > schema changes are within 1.2.x.
> 
> 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.

 
I don't think the dbm/dba backend is broken, so no problems there.

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.)

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.

Jeff