RE: bytes vs chars

From: Ahmed Aangour <ahmed.aangour_at_gmail.com>
Date: Fri, 11 Mar 2016 18:16:14 +0100
Message-ID: <CAPK9FYEJ5XS1kAcg129+UJS7W18QbmBUXGzVDV1QoKh7aWHH_g_at_mail.gmail.com>

It depends on the characterset used for your database. Please select nls_database_parameters
Le 11 mars 2016 5:56 PM, "Zelli, Brian" <Brian.Zelli_at_roswellpark.org> a écrit :

> So if nls_length_semantics is set to byte, can I assume the 1 char = 1
> byte rule?
>
>
> Brian
>
>
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of Hans Forbrich
> Sent: Friday, March 11, 2016 11:48 AM
> To: oracle-l_at_freelists.org
> Subject: Re: bytes vs chars
>
> 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
>
>
>
>
> This email message may contain legally privileged and/or confidential
> information. If you are not the intended recipient(s), or the employee or
> agent responsible for the delivery of this message to the intended
> recipient(s), you are hereby notified that any disclosure, copying,
> distribution, or use of this email message is prohibited. If you have
> received this message in error, please notify the sender immediately by
> e-mail and delete this email message from your computer. Thank you.

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

Received on Fri Mar 11 2016 - 18:16:14 CET