Re: how to return special character from sql?

In article <#boDc0SeAHA.282_at_cpmsnbbsa09>,   "Ling" <circetsui_at_msn.com> wrote:
> Hi all,
>
> Does anybody know how to return a special character from sql,
 specially the
> ' ->' symbol ? I thought maybe I could use chr() function, but I
 couldn't
> find the correct number that can return this symbol, maybe it's
 because it
> is not in ASCII character set. I can make MS Excel / word to display a
> character like that. But don't know how to do it in Oracle.
>
> Please help.
>
> Ling
>
>

the only way to do this is to use a characterset which supports the symbol. Evidently you are not doing that. To check out which characters your installation supports use a loop in pl/sql for i in 1..255 loop dbms_output.put_line(chr(i)) The check out parameters
use
select * from nls_database_parameters
and
select * from nls_session_parameters
If the former shows an 8 bit charset and the latter 7 bit, you'll need to set the NLS_LANG variable either in the registry (in HKLM\software\oracle) or as env var (Unix)

Hth,

--
Sybrand Bakker, Oracle DBA

All standard disclaimers apply
------------------------------------------------------------------------


Sent via Deja.com
http://www.deja.com/