title: is a query portable if the where-clause-value exceeds the column length?
body: <p>If I have an <code>acct_id CHAR(3)</code> and a query like</p>
  
  <pre><code>select * from some_table where acct_id like '12%3%';
  </code></pre>
  
  <p>will most relational databases accept this query or will some fail because I'm comparing a value longer than the column?</p>
  
  <p>In other words: <strong>will this query be portable across typical databases (like MySql, DB2, and Oracle) if my where clause exceeds the column's limit?</strong></p>
  
  <p>Also, Is the same true for an <code>=</code> comparison instead of <code>LIKE</code>?</p>
  
  <p>I tried a query on DB2 (x86 and mainframe) and it didn't cause any errors, but I wasn't sure about other databases. I looked through the titles of several SO questions before submitting.</p>