Re: Can you explian the output of this SQL?

I think there is something in UTF8 implementation that strips the first char. Try different datatypes, or change to ASCII, or some two-byte char. (utf's size is 'dynamic', that's what that first byte might be used for).

I saw this few years ago, so don't remember all the details.

On Mon, 20 May 2002 16:48:18 +0100, InsaneGadgets.com <rob_at_insanegadgets.spambait.com> wrote:

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

.......
We use Oracle 8.1.7.3 on Solaris 2.7 boxes remove NSPAM to email Received on Mon May 20 2002 - 11:50:51 CDT