Re: bytes vs chars

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.

Regards,
Ahmed
Le 11 mars 2016 16:39, "Zelli, Brian" <Brian.Zelli_at_roswellpark.org> a écrit :

> I have a system 11g on AIX. Table characters are defined in bytes not
> chars. I am trying to figure out if a column that has 25 bytes is big
> enough. They are saying the column changed from 15 characters to 30. Do I
> have to change the column to 30 bytes? It is a name field. Or does it
> depend on the character set? I tried looking for that under database
> options but couldn’t find it.
>
>
>
>
>
> Brian
>
>
>
>
>
> 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