title: Php Prepared Statements Turn Emulation Off
body: <p>Are there any side effects to turning off emulation when using prepared statements with pdo? I'm using a select * and limiting the results which needs to be handled as an int and not a string. I can do one of two things.</p>
  
  <pre><code>$conn-&gt;setAttribute( PDO::ATTR_EMULATE_PREPARES, false );
  </code></pre>
  
  <p>Or to bind these variables explicitly with param type:</p>
  
  <pre><code>$stm = $pdo-&gt;prepare('SELECT * FROM table LIMIT ?, ?');
  $stm-&gt;bindParam(1, $limit_from,PDO::PARAM_INT);
  $stm-&gt;bindParam(2, $per_page,PDO::PARAM_INT);
  $stm-&gt;execute();
  $data = $stm-&gt;fetchAll();
  </code></pre>
  
  <p>Any pros or cons? Obviously turning emulation off would save a lot of binding.</p>