Re: UTL_RAW.CAST_TO_VARCHAR2

  • From: Martin Berger <martin.a.berger@xxxxxxxxx>
  • To: leizeng2003@xxxxxxxxx
  • Date: Thu, 14 Mar 2013 20:06:46 +0100

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@xxxxxxxxx> 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▒▒▒    @     ▒  @   @
>       ▒▒gg▒  ▒ ▒▒▒▒▒▒  ▒▒
>
> (((P  ▒  @)(((▒▒  ▒A▒
>                       ▒▒ @ ▒
>
> How
> I can get a meaningful string from UTL_RAW.CAST_TO_VARCHAR2?
> Did I miss anything?
>
> Thanks in advance,
> Lei
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>

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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 03-2013