Re: Oracle 8.i --> Oracle 9i + Unicode

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Sat, 13 Sep 2003 08:23:53 +1000
Message-Id: <3f6247e9$0$6527$afc38c87@news.optusnet.com.au>

Tanel Poder wrote:

>> It depends. UTF8 (now called something like AL32UTF8) is a variable-width
>> encoding, where letters like "t", "e" and "a" are single byte characters.
>> But letters like "?" "� and "?" are double bytes. And then Chinese,
>> Korean, Arabic and so on 'characters' can be triple or even quadruple

>
> Just for correctness, letter �is 3 bytes in UTF-8 for some reason. So is
> non-capital "�. Both letters are used in Estonian, Finnish, Swedish +
> several other Northern-Europe languages. Strange that these letters have
> been ranked that low...
> (note that capital "� is only 2 bytes, while non-capital "� is 3)
>
> SQL> select value from nls_database_parameters where parameter =
> 'NLS_CHARACTERSET';
>
> VALUE
> ----------------------------------------
> UTF8
>
> SQL> desc t;
> Name Null? Type
> ----------------- -------- ------------
> A VARCHAR2(10)
>
> SQL> select a, vsize(a) from t;
>
> A VSIZE(A)
> ---------- ----------
> � 3
> � 2
> 3
> � 3
>
> Tanel.

I wish I knew the characters you were talking about! My newsreader can't cope!!

Regards
HJR Received on Fri Sep 12 2003 - 17:23:53 CDT