title: why excel export csv doesn't quote single quote?
body: <p>When I export the data from excel as a CSV format it encapsulates some data in double quotes. 
  E.g.</p>
  
  <ol>
  <li><code>8"</code> becomes <code>"8"""</code>. And I believe this operation is trying to get the database to understand the inside quote later on.</li>
  <li>but for single quote <code>8'</code>, it keeps the same and this causes problem(see the pic below) while I am importing the csv.</li>
  </ol>
  
  <p>Why not quoting the <code>8'</code> into <code>"8'"</code> too?</p>
  
  <p><strong><code>8'</code> becomes <code>'</code> while importing, while <code>"8'"</code> will result in <code>8'</code> And not quoting single quote leads some data loss.</strong>
  <a href="https://i.stack.imgur.com/Tyl0y.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Tyl0y.png" alt="enter image description here"></a></p>
  
  <p>question related:<br>
  <a href="https://stackoverflow.com/questions/50472683/what-does-quotechar-mean-in-mysql-while-importing-data/50473102#50473102">what does quotechar mean in mysql while importing data?</a></p>
  
  <p><a href="https://stackoverflow.com/questions/5200056/excel-adds-extra-quotes-on-csv-export">Excel adds extra quotes on CSV export</a></p>