title: Need for understanding in Oracle with NLS_LENGTH_SEMANTICS
body: <p>I create DataBase and table in Oracle 12c with :</p>
  
  <pre><code>CREATE TABLE t
  (a VARCHAR2(14 CHAR))
  </code></pre>
  
  <p>If I try to put : MARIE-THÉRÈSE</p>
  
  <pre><code>INSERT INTO t (a) values ('MARIE-THÉRÈSE');
  
  ERROR at line 1:
  ORA-12899: value too large for column "T"."A" (actual: 15, maximum:
  14)
  </code></pre>
  
  <p>Some information :</p>
  
  <pre><code>    SQL&gt; SELECT LENGTH('MARIE-THÉRÈSE') "Length in characters" FROM DUAL;
  
  Length in characters
  --------------------
                    15
  SQL&gt; SELECT LENGTHB ('MARIE-THÉRÈSE') "Length in bytes" FROM DUAL;
  
  Length in bytes
  ---------------
               23
  SELECT *
     FROM nls_database_parameters
     WHERE parameter = 'NLS_CHARACTERSET';
  
  PARAMETER                      VALUE
  ------------------------------ --------------------
  NLS_CHARACTERSET               AL32UTF8
  
  SELECT value FROM NLS_DATABASE_PARAMETER
  WHERE parameter='NLS_LENGTH_SEMANTICS';
  
  VALUE
  -----------------------------------
  BYTE
  </code></pre>
  
  <p>How it will be possible to put 'MARIE-THÉRÈSE' in this column VARCHAR2(14 CHAR) without modified this column but only oracle parameters ?</p>