> On Sep 8, 2015, at 3:42 PM, Steve Baldwin <stbald...@multiservice.com> 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
