Tags: 
PHP and Oracle Manual
Maggie writes about an Oracle problem over which we were pulling out our hair. In the end, the solution was fairly simple, but I’ll let you read her post for all the details. I’ll just mention that Christopher Jones pointed me to a freely available book he and Alison Holloway wrote specifically for PHP developers using Oracle: The Underground PHP and Oracle Manual.
Christopher says, “The book is designed to bridge the gap between the many PHP and the many Oracle texts available.” This is a must-read for anyone using Oracle and PHP together, and they continually maintain it and keep it up-to-date.
On page 80 of the manual, it states:
If you are using an Oracle Database 10g Release 2 database other than the Express Edition (“XE”), you may need to give the Apache process access to Oracle’s libraries and globalization data. Refer to the $ORACLE_HOME/install/changePerm.sh script. Each time you restart Apache, make sure you have the same environment variables set for Oracle. In particular
ORACLE_HOMEshould always be set.
Wiser words were never writ…
[...] As mentioned by Ben Ramsey today, Maggie Nelson bumped into an issue in one of her applications with character sets and the incorrect storage/retrieval of information: Even Oracle, which usually gets storing of data right on the money has had issues with character sets. […] Needless to say, even when you know you set up your database correctly for supporting UTF8, the path to debug issues may be frustrating and full of red herrings. [...]
Wed, 13 Jun 2007 at 16:24 UTC | Permalink