Re: Character confusion

"Marcel Stör" <marcel at frightanic dot com> writes:

> That helped big time! CGI is fine now. On problem that remains is, that my
> xterm console somehow doesn't know anything about ISO Latin 1 and displays a
> blank instead of an umlaut.

You should create a xterm with a font that supports the iso8859-15 encoding. X11 normally installs a tool xfontsel. If you start this program you can can look for a font that suports the Euro. Choose here for in the last column of the xfontsel window - it's called 'encdng' - a entry with '15'. Here an example:

,----
| $ xterm -fn '-*-fixed-*-r-*-*-13-*-15'
`----

Now start in that xterm sqlplus with the right NLS_LANG variable.

,----
| $ NLS_LANG=german_germany.we8iso8859p15 sqlplus scott/tiger
|
| SQL*Plus: Release 9.2.0.4.0 - Production on Sa Sep 6 07:16:09 2003
|
| Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
|
|
| Connected to:
| Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
| With the Partitioning, Oracle Label Security ...
| JServer Release 9.2.0.4.0 - Production
|
| SQL> select to_char(123,'L999') from dual;
|
| TO_CHAR(123,'L
| --------------
| ¤123

`----

Harald Received on Sat Sep 06 2003 - 00:22:33 CDT