title: ORA-12899: value too large for column - on export/import, both BYTE semantics, not CHAR
body: <p>I have an Oracle DB on one Windows machine and perform an export of all tables + contents using SQL developer 4.0.2.15. File format is plain text SQL, ANSI ISO-8859-1. The line endings are done in UNIX style (1 byte).
  The table / column definitions are like:</p>
  
  <pre><code>"PRODUCTNAME" VARCHAR2(120 BYTE),
  </code></pre>
  
  <p>When I execute this .sql file on the target Windows machine, tables are created and inserts are done. But some items that have exactly 120 bytes in the PRODUCTNAME (including 1 line feed character) fail to insert on the target machine.
  I get:</p>
  
  <blockquote>
    <p>ORA-12899: value too large for column "DBNAME"."TABLENAME"."PRODUCTNAME" (actual: 121, maximum: 120)</p>
  </blockquote>
  
  <p>I don't understand why. I have no 2-byte characters in this particular string, and the export is definitely done using 0x0A as line break character (checked via Notepad++ status line and its HexView Plugin). I use drag&amp;drop to open the .sql file in the target machine's SQL developer (same version). When I copy the productname with its line break into Notepad++ via clipboard, it count's 120 bytes of length.</p>
  
  <p>I do not understand, why in Oracle developer the script counts this 1 extra character.</p>
  
  <p>I have searched for this in google and found topics here on SO among others, but they don't help me or I don't fully understand them.</p>
  
  <p>What do I miss? Please help!</p>