Re: UTL_RAW.CAST_TO_VARCHAR2

From: Martin Berger <martin.a.berger_at_gmail.com>
Date: Thu, 14 Mar 2013 20:06:46 +0100
Message-ID: <CALH8A924VGJJKqY1882B-jG9nV9_aAh3ipnLdRt7FmMusepBYQ_at_mail.gmail.com>

Hi Lei,
maybe this blog entry might help?
http://mwidlake.wordpress.com/2010/01/03/decoding-high_value-and-low_value/

Martin wrote several articles about this issue.

hth
 Martin

On Mon, Feb 4, 2013 at 11:09 PM, Lei Zeng <leizeng2003_at_yahoo.com> wrote:

> Hi, list:
> I
> have a quick question about UTL_RAW.CAST_TO_VARCHAR2
>
> Database
> version 11.2.0.2
> Database
> character set UTF8
> I
> set NLS_LANG before using SQLPLUS
>
> export
> NLS_LANG=AMERICAN_AMERICA.UTF8
> SQL> select
> utl_raw.cast_to_varchar2(OPTIMIZER_ENV)
> from D 2 BA_HIST_OPTIMIZER_ENV where
> optimizer_env_hash_value)66359101;
>
> UTL_RAW.CAST_TO_VARCHAR2(OPTIMIZER_ENV)
>
> --------------------------------------------------------------------------------
> ▒▒▒▒&▒
> = ▒▒▒▒▒▒3 VAEUQ▒!UUUETUXYUD▒e▒U▒UUQUQQ"UT▒▒
> UQEBeETT▒▒Vn
> ▒ETPDi▒▒▒ _at_ ▒ @ @
> ▒▒gg▒ ▒ ▒▒▒▒▒▒ ▒▒
>
> (((P ▒ _at_)(((▒▒ ▒A▒
> ▒▒ _at_ ▒
>
> How
> I can get a meaningful string from UTL_RAW.CAST_TO_VARCHAR2?
> Did I miss anything?
>
> Thanks in advance,
> Lei
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Mar 14 2013 - 20:06:46 CET