Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to query a string in Hex or byte format

Re: How to query a string in Hex or byte format

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 18 Oct 2005 22:41:52 -0700
Message-ID: <1129700508.16666@yasure>


Jim Kennedy wrote:

> <vwu_at_anacomp.com> wrote in message
> news:1129684464.938577.109240_at_o13g2000cwo.googlegroups.com...
> 

>>Hi,
>>
>>I suspect the string I query is different than what it was actually
>>stored in the database table since the NLS setting are different
>>between the database server and the code page used for the display on
>>the client machine, so how can I query a string such as a person's name
>>in Hex or byte format.
>>
>>Thank You
>>Vance
>>
> 
> I think there is a dump command.   See the docs. (eg otn.oracle.com)
> Jim

Example of BLOCK DUMP is on the psoug.org web site in Morgan's Library.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Wed Oct 19 2005 - 00:41:52 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US