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

vwu_at_anacomp.com wrote:
> The NLS_LANG on the Oracle Client machine (Sun) is WE8ISO8859P1, the
> database is UTF8, I check the code pages on these two character sets
> they both represent character Ñ as 0xD1, but when I query the string
> in Hex form using RAWTOHEX() function, found out in 8i it converted to
> character Q (0x51), in 9i it converted to character ¿ (0xBF)
>

What is the character set of the databases? I suspect US7ASCII for 8i (it used to be the default for 8i);
0x51=0101 0001, 0xD1=1101 0001, when the msb is dropped, you get 0x51!

0xBF = chr(191), or ¿, indeed. Can you actually see the string correctly when doing "insert into test values ('COFIÑO');" ?

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...