title: Oracle SQL - Substr not removing enough characters
body: <p>I am facing a strange issue. I have code like this.</p>
  
  <pre><code>insert into my_table
      substr(my_name,1,199)
  </code></pre>
  
  <p>The error given is:</p>
  
  <p>value too large for column ... (actual: 246, maximum: 200)</p>
  
  <p>Looking at the largest names in my table, I've got stuff like:" 8&#34;x12&amp;#34 "</p>
  
  <p>Is is possible that some character set stuff is going on, so that when it inserts, the number of characters increases? If so, how do I rememdy that? I've tried explicitly converting  to UTF8 before substringing, but that doesn't help at all.</p>