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

From: Dave <solomons_dad.w.marks_and_whom_at_oracle.com>
Date: Wed, 19 Oct 2005 14:28:12 +0100
Message-ID: <V4s5f.30$xH6.116@news.oracle.com>

vwu_at_anacomp.com wrote:
> vwu_at_anacomp.com wrote:
>

>>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

>
>
> The NLS setting for the Sun OS on my Oracle client machine is en
> US.ISO8859-1, my Oracle8i and Oracle9i database character sets are both
> set to UTF-8, when I insert string "COFIÑO" into the 8i & 9i databases
> via my Oracle client machine, on the Oracle8i I believe it
> automatically converted to "COFIQO", and on the Oracle9i it converted
> to "COFI¿O", the string data type is VARCHAR2.
>
> Can someone tell me why and how to fix it?
>
> Thanks,
> Vance
>

If characters are incorrectly stored in the database you almost certainly have a characterset mismatch. Check the characters you want to use in Locale Builder - this allows you to query charactersets to find out how characters are represented.

You didn't say what NLS_LANG is on the client; Oracle Net uses that to determine how to translate characters. The most likely explanation is that your NLS_LANG doesn't represent Ñ, since this is almost certainly represented in UTF8. Received on Wed Oct 19 2005 - 08:28:12 CDT