Re: Can you explian the output of this SQL?

On Mon, 20 May 2002 23:17:55 +0100, Andy Hassall <andy_at_andyh.org> wrote:

>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);
>
> That doesn't look at all right.
>
>http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/server.920/a96540/functions18a.htm#SQLRF00616
>For multibyte character sets, this sort of concatenation gives different
>results. For example, given a multibyte character whose hexadecimal value

Andy,

Thanks for taking the time to answer my question. It was very helpful and is much appreciated!

Rob Received on Tue May 21 2002 - 04:36:38 CDT