Has anyone managed to get phpwiki working with oracle? There isnt a table generation script for oracle, and I wanted to check for one before I modified one to fit oracle, and to see if there are any issues with phpwiki running in an oracle database (I'd prefer this over a file-based-db).
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Longer answer:
It is not straightforward...
Main problems are:
- The current SQL in the Pear backend is not always standard, some statements need to be re-written
- The way Oracle handle empty strings (NULLs) is also problematic
- Length of character strings is limited in Oracle, so some statements in the backend need to be re-written as well
- Not to speak about column/table case handling.
But appart from that it runs like a breeze on a 10g database.
If there is some interrest in the community I can polish a bit my oci8 backend and release it...
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Thanks guys! As soon as I figure out CVS I'll get at the source and run it (I'm not sure if I'm doing something wrong or my office has blocked the port CVS uses).
Thanks again!
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Has anyone managed to get phpwiki working with oracle? There isnt a table generation script for oracle, and I wanted to check for one before I modified one to fit oracle, and to see if there are any issues with phpwiki running in an oracle database (I'd prefer this over a file-based-db).
Short answer: Yes I do!
Longer answer:
It is not straightforward...
Main problems are:
- The current SQL in the Pear backend is not always standard, some statements need to be re-written
- The way Oracle handle empty strings (NULLs) is also problematic
- Length of character strings is limited in Oracle, so some statements in the backend need to be re-written as well
- Not to speak about column/table case handling.
But appart from that it runs like a breeze on a 10g database.
If there is some interrest in the community I can polish a bit my oci8 backend and release it...
I can polish it also.
You work would be very appreciated.
Oracle support was added lately to current CVS. (pear only)
Thanks to Philippe Vanhaessendonck
Thanks guys! As soon as I figure out CVS I'll get at the source and run it (I'm not sure if I'm doing something wrong or my office has blocked the port CVS uses).
Thanks again!