[PHP-DOC] Bug #11220 Updated: special chars insertion into oracle / NLS_LANG From: mfischer <email protected>
Date: 06/08/02

 ID: 11220
 Updated by: mfischer <email protected>
 Reported By: izzy <email protected>
-Status: Analyzed
+Status: Closed
 Bug Type: Documentation problem
 Operating System: SuSE Linux 7.0 / 7.1
 PHP Version: 4.0.5
 New Comment:

It's not our problem/job what values to use. There are *tons* of oracle
documentation out there. Oracle is not a kiddy database, so people
should read the books. Closing.

Previous Comments:
------------------------------------------------------------------------

[2001-06-01 15:59:34] sniper <email protected>

The current documentation does mention all
these environment vars that should be used,
but doesn't have any examples/information what
to set as the values.

------------------------------------------------------------------------

[2001-06-01 02:45:38] izzy <email protected>

Just found somebody to do the job on the server. Following
is the solution:

export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export NLS_LANG=<language>_<country>.<charset>

of course, after setting all the other environment
variables, especially ORACLE_HOME ;)

So you may now a) consider this bug closed and b) add this
solution to the dox/faq. I will go look at the online dox
if I can add a "user comment" meanwhile ;)

Again, thank you for your fast help and solution!

Izzy.

------------------------------------------------------------------------

[2001-06-01 02:15:36] izzy <email protected>

Other than I wrote in my mail (in-reply-to your comment),
it appears that the setting of ORA_NLS33 *before* NLS_LANG
brings the "Lock" down - at least I can connect to the
database with it (which I couldn't without). But since I
have no necessary permission to set those vars in the
Apache startup script (missing the root login to that
server ;) I can't tell now wether it really *solves* the
problem, since I only can use putenv() for testing here
(the setting with putenv() seems to have no effect, I
still get the "old" default settings by "SELECT
USERENV('LANGUAGE') FROM dual". As soon as I can check
that with the server admin I will do - and report it here
then.
Thanx for your help so far!
Izzy.

------------------------------------------------------------------------

[2001-05-31 18:21:04] sniper <email protected>

As you are from Germany you might understand this better:

http://www.php-center.de/faq/faq-database_oracle.html

I'm not 100% sure it has the answer..but seems like it. :)
Please let us know if it does so some of it could
be added to our manual.

--Jani

------------------------------------------------------------------------

[2001-05-31 13:50:42] izzy <email protected>

Having problems to insert special chars (as German Umlaute
like "äöü") into oracle using oci8 functions. Tried to set
NLS_LANG=GERMAN_GERMANY.WE8ISO8859P15 (as we use for all
other applications here), but then I am not even able to
connect to the database any more.
I saw some other bugs similiar to this one, some closed
but still unsolved - I hope I have more luck with an
answer helping me to solve my problem. Since I'm already
asked a couple of times to migrate to Java... No answer
will be a bad answer :)
If special settings (like php.ini or configure line) are
relevant, please let me know - so I'll supply them.
Thanx
Izzy.

------------------------------------------------------------------------ 

-- 
Edit this bug report at http://bugs.php.net/?id=11220&edit=1