When I connect with sqlplus (windows 7, cmd) to a oracle database and query with umlauts (ü, ö, ä) I don't get anything back.

I queried for the NLS\_LANG and got following back: 

```
AMERICAN_AMERICA.WE8ISO8859P1

```

The oracle database runs on a linux distribution. So I opened the cmd box and entered

```
set NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1

```

and repeated the query - once more without success. Then I got following hint:

```
set NLS_LANG=German_Germany.WE8PC850'

```

This worked - finally. But I want to use the query statement in joomla. And now I don't know how to handle with this problem. I use oci8 and oracle10g. Any ideas?

Thanks in advance.