


  
  <div class="section" id="encryption-functions">
<h1>Encryption Functions<a class="headerlink" href="#encryption-functions" title="Permalink to this headline">¶</a></h1>
<p>Encryption functions encrypt or decrypt VARCHAR or BINARY values.</p>
<table class="docutils align-default">
<colgroup>
<col style="width: 41%">
<col style="width: 59%">
</colgroup>
<thead>
<tr class="row-odd"><th class="head"><p>Function</p></th>
<th class="head"><p>Notes</p></th>
</tr>
</thead>
<tbody>
<tr class="row-even"><td><p><a class="reference internal" href="functions/encrypt"><span class="doc">ENCRYPT</span></a></p></td>
<td><p>Encrypts VARCHAR or BINARY values using a passphrase.</p></td>
</tr>
<tr class="row-odd"><td><p><a class="reference internal" href="functions/decrypt"><span class="doc">DECRYPT</span></a></p></td>
<td><p>Decrypts VARCHAR or BINARY values using a passphrase.</p></td>
</tr>
<tr class="row-even"><td><p><a class="reference internal" href="functions/encrypt_raw"><span class="doc">ENCRYPT_RAW</span></a></p></td>
<td><p>Encrypts BINARY values using a binary key and an initialization vector.</p></td>
</tr>
<tr class="row-odd"><td><p><a class="reference internal" href="functions/decrypt_raw"><span class="doc">DECRYPT_RAW</span></a></p></td>
<td><p>Decrypts BINARY values using a binary key and an initialization vector.</p></td>
</tr>
</tbody>
</table>
</div>




Function	Notes
ENCRYPT	Encrypts VARCHAR or BINARY values using a passphrase.
DECRYPT	Decrypts VARCHAR or BINARY values using a passphrase.
ENCRYPT_RAW	Encrypts BINARY values using a binary key and an initialization vector.
DECRYPT_RAW	Decrypts BINARY values using a binary key and an initialization vector.

Encryption Functions¶