Re: Oracle character column sizes from {PRECISION}

> On Sep 8, 2015, at 3:42 PM, Steve Baldwin <[email protected]> wrote:
> 
> I have a table defined as follows:
> 
> SQL> desc sb1
>  Name                          Null?    Type
>  ----------------------------- -------- --------------------
>  C1                                     VARCHAR2(30 CHAR)
>  C2                                     VARCHAR2(30)
> 
> Note the difference is the character semantics, c1 is CHAR, c2 is BYTE.
> 

isn’t that dependent on what ns_lang is set to? for single-byte encoding this is correct, as 30 char == 30 bytes.

<http://www.dba-oracle.com/t_nls_lang.htm>

-- 
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group

Institutions do not have opinions, merely customs