no "umlaute" / "alter session" has no effect

Hi,

I'm accessing a ORACLE-Server from a univeristy Web-Server via PHP (oci8) and for testing purposes from a lokal Web-Server on a Windows-MAchine (oci8 / XAMPP).

Since I set the NLS_LANG-Param on my local machine I have no problems with the german "Umlaute". "alter session set NLS_DATE_FORMAT='dd-mm-yyyy'" works as well.

BUT NOW, on the university-server neither the setting of NLS_LANG (using "putenv(...)") nor the "alter session" has any effect. They use a ZEUS-Webserver.

Thank you for any help.

NLS support has to be installed, it usually is by default.

ALTER SESSION should work, as far as I've seen. Do you get errors with ALTER SESSION? What are they?

What ASCII character is displayed for a character that should be umlaute-u on your keyboard? You can call ASCII() in SQLPLUS to determine the ASCII value.



Next insert that value in a field in a temp table, and try the same thing.

The query "SELECT ASCII('Ü') FROM DUAL"

leads to the following result:

911 ORA-00911: invalid character

"ALTER SESSION" produces no erros.

Give you what output?

It sounds like something was not installed, like NLS support.

hello,

just try the convert function for example:

select
convert(something,'WE8ISO8859P1')
from
table;

help convert
gives the parameters to use.

CONVERT(char, dest_char_set [,source_char_set] )


I hope I could help you.