RE: bytes vs chars
Date: Fri, 11 Mar 2016 16:55:20 +0000
Message-ID: <BY2PR1201MB1080418B25FA4ABE44CD5874F4B50_at_BY2PR1201MB1080.namprd12.prod.outlook.com>
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.†Ûiÿü0ÁúÞzX¬¶Ê+ƒü n– {ú+iÉ^ Received on Fri Mar 11 2016 - 17:55:20 CET