News Feed
Sections




News Archive
Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

Maggie Nelson's Blog:
When PHP and Oracle assume the worst about each other
June 13, 2007 @ 10:10:00

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.

She mentions the setup the application is using (NLS_CHARACTERSET AL32UTF8, NLS_NCHAR_CHARACTERSET AL16UTF16) but something wasn't right. The problem popped up when they tried to store Chinese characters into the database with the result of invalid data on a select.

After following several different leads, they finally came upon the culprit - the Apache process didn't have the access it needed to a directory in the ORACLE_HOME. In the end, it all only broke down into three easy steps to fix a very frustrating issue.

0 comments voice your opinion now!
oracle utf8 characterset nls unicode oracle utf8 characterset nls unicode


blog comments powered by Disqus

Similar Posts

Gennady Feldman's Blog: Installing Oracle Instant Client 11g and PECL OCI8 (Part 2)

Zend Developer Zone: PHP Abstract Podcast Episode 21: PHP and Oracle

Richard Davey\'s Blog: Prepare for PHP 6

Padraic Brady's Blog: ZF Blog Tutorial Addendum #1: Base URL, Magic Quotes, Database Schema & UTF-8

Rob Richards' Blog: Book Review: PHP Oracle Web Development


Community Events





Don't see your event here?
Let us know!


podcast community api zendserver code series threedevsandamaybe bugfix list symfony release voicesoftheelephpant laravel conference framework introduction tips language deployment interview

All content copyright, 2014 PHPDeveloper.org :: info@phpdeveloper.org - Powered by the Solar PHP Framework