Re: bytes vs chars

From: Ahmed Aangour <ahmed.aangour_at_gmail.com>
Date: Fri, 11 Mar 2016 18:12:40 +0100
Message-ID: <CAPK9FYFpNrWkqWZOHakpv4wYXfY-4HhyhyBm7uechrUiFyi+RQ_at_mail.gmail.com>

My mistake. Thank you Hans I indeed wanted to say single-byte instead of unicode.
Le 11 mars 2016 5:48 PM, "Hans Forbrich" <fuzzy.graybeard_at_gmail.com> a écrit :

> I think the sentiment is correct, but there is a minor correction to the
> wording:
>
> Unicode is an attempt to get all different character sets into one
> superset, and is multi-byte in nature. The AL32UTF8 encoding for Unicode
> allows a character to be represented in the fewest required of 1, 2, 3 or 4
> bytes, based on the Quick Link 'Code Charts' at http://unicode.org/
>
> The 1 character = 1 byte group are often known as 'single byte character
> sets' or 'single byte encoding'. These include ASCII and various ISO 8859
> sets. A handy reference is at
> http://docs.oracle.com/database/121/NLSPG/ch2charset.htm#NLSPG166
>
> Therefore, I think the statement should be corrected to
>
> "If you're using a single-byte characterset then 1character = 1 byte.
> But if you're using a multibyte Unicode characterset then a character can
> be coded on several bytes."
>
> /Hans
>
> On 11/03/2016 8:50 AM, Ahmed Aangour wrote:
>
>>
>> Hi,
>>
>> If you're using a unicode characterset then 1character = 1 byte. But if
>> you're using a multibyte characterset then a character can be coded on
>> several bytes.
>> You can check the character set of the database by querying
>> nls_database_parameters.
>>
>>
>>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Mar 11 2016 - 18:12:40 CET