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 -> Can you explian the output of this SQL?

Can you explian the output of this SQL?

From: InsaneGadgets.com <rob_at_insanegadgets.spambait.com>
Date: Mon, 20 May 2002 16:48:18 +0100
Message-ID: <k76ieuofkjo5kterpssorhig85ufr2sosv@4ax.com>


My database is i UTF8 format.

If I run this script...



update mytable set mycolumn = chr(229)||chr(148)||chr(180);

commit;

select dump(mycolumn,1010) from mytable;


This should set a column to a unicode character 0x5534 and then display it. What it actually returns is..



Typ=1 Len=2 CharacterSet=UTF8: 148, 180

If you notice the first byte #229 seems to have been stripped. What would cause this?

Thanks, Received on Mon May 20 2002 - 10:48:18 CDT

Original text of this message

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