diegomann@yahoo.com
|
| Posted: 04/13/2002, 11:30 PM |
|
Hi!
Please...
I set the Oracle 8 database correctly in spanish. NLS is working
fine... but when I try to display a grid with N records on it...
the result is ?
What's wrong? I am 100% sure the database is in spanish, I run in
a NT SERVER+PHP+ORACLE+SPANISH and it's working fine...
when I "publish" it in the LINUX RedHat 6.2 server... no more N.
any ideas?
Please... help
THANKS IN ADVANCE
DIEGO URRA
|
|
|
 |
Alex Alexapolsky
|
| Posted: 04/15/2002, 1:56 AM |
|
What is your CC version ?
|
|
|
|
diegomann@yahoo.com
|
| Posted: 04/15/2002, 4:17 PM |
|
I am using
Oracle 8.1.7
PHP 4.12
Apace 1.3.24
CC 2.0.3
RedHat 6.2
Please... help me
THANKS IN ADVANCE
|
|
|
|
oracle master
|
| Posted: 04/18/2002, 5:56 PM |
|
--->> Let me know if it helps ......
This article describes how to display 8-bit characters
(for example, n)
Why This Problem Occurs
=======================
This problem occurs if you transfer the binary file to UNIX
and you use the Developer 6.0 default installation. When you
execute a form on Windows, by default the NLS_LANG value is
AMERICAN_AMERICA.WE8ISO8859P1. This means that the form is
executed with the language set to American, Territory America,
which is an 8-bit character set that does not include Spanish
characters. Thus, you must explicitly define the NLS_LANG
environment variable to use a character set that correctly
displays Spanish language characters.
Setting the NLS_LANG Variable on Sun Platforms
==============================================
On the Sun platform, define the NLS_LANG environment variable
to use the character set WE8ISO8859P1.
Setting the NLS_LANG Variable on HP Platforms
=============================================
On the HP platform, define the NLS_LANG environment variable
to use the character set WE8HP.
Examples
========
The values of this environment variable, language and territory,
take effect on the Forms and Reports directly, but they do not
effect the custom definition on the reports and forms modules. For
example:
-- If you have Language and territory set to AMERICAN, AMERICA and
the character set at 8-bits (WE8ISO8859P1 or WE8HP,) all internal
definitions of Forms Runtime and Reports Runtime appear in
English, but the labels and hints appear with Spanish characters.
-- If you have Language and territory set to SPANISH, SPAIN and the
character set at 8-bits (WE8ISO8859P1 or WE8HP,) all internal
definitions of Forms Runtime and Reports Runtime appear
in Spanish, as do the the labels and hints.
|
|
|
|
diegomann
|
| Posted: 04/18/2002, 8:41 PM |
|
Thanks a lot oracle master.
The NLS_LANG = SPANISH_SPAIN.WE8ISO8859P1
that's ok. I saw the N with sqlplus at the console.
There is no problem.
The "locale" command says "es_ES", everything is
fine... but PHP with oci8 still doesn't display the n correct...
what's it? what can I do?
I am desperate...
How to set HTTP_ENV_VARS?
Thanks a lot
DIEGO URRA
|
|
|
|
oracle master
|
| Posted: 04/19/2002, 7:31 PM |
|
Under UNIX the setup is as follows:
export ORA_NLS33=/u00/oracle/product/8.1.7/nls/admin/data
export NLS_LANG="AMERICAN_AMERICA.US7ASCII"
export NLS_DATE_FORMAT="YYYY-MM-DD"
Under NT, I think that you need to use something like
set ORA_NLS33=/u00/oracle/product/8.1.7/nls/admin/data
set NLS_LANG="AMERICAN_AMERICA.US7ASCII"
set NLS_DATE_FORMAT="YYYY-MM-DD"
substituting the right parameters for NLS_LANG and NLS_DATE_FORMAT
and ORA_NLS33
I think that Apache under NT starts as a batch so you can either
modify the batch or setting up enviromental variables. I am not sure
if you also need to check the setup of the registry because it seems
Apache does not read that.
Tested out with the environment, if you type set under a command prompt
you should see all that has been setup and maybe that env is not set
as an enviromental variable and that is why php and Apache uses default
values.
Note, if you setup those env and the database does not start there is
an error. You need to match exactly the language that the database
reports.
Let me know if that works. I am not sure if this is a solution, but
I think it might work. The reason for that is that I used such a setup
to modify the way php Apache displays the date and that is why the
NLS_DATE_FORMAT="YYYY-MM-DD" that I have included. I found out that
eventhough init.ora had that setup, php had a mind of its own when it
came to fomating the date andthat is how I achieved getting php/Apache
to change the default date regardless of what was on init.ora
Best regards,
-me <lol>
|
|
|
|
oracle master
|
| Posted: 04/22/2002, 8:16 PM |
|
It would be nice to know if that fix your problem ?
|
|
|
|
|
