title: ORA-12899 value too large for column despite of same length
body: <p>I am running the following query. But getting ORA-12899. Altough the length of string am trying to insert is 30.</p>
  
  <pre><code>INSERT INTO TABLE1 SELECT * FROM temp_Table1 where LENGTH(column1)=30;
  
  SQL Error: ORA-12899:value too large for column "TABLE1"."column1" (actual: 31, maximum: 30)
  
  
  select column1 from temp_Table1 where LENGTH(column1)=30;
  
  Testing  - HLC/TC Design Corre
  
  Desc temp_Table1
  
  column1 VARCHAR2(30)
  
  Desc Table1
  
  column1 VARCHAR2(30)
  </code></pre>