ID: 11220
Updated by: [EMAIL PROTECTED]
Reported By: [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] [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] [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] [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] [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] [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
