


  
  <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="colwidths-given docutils align-default">
<colgroup>
<col style="width: 30%">
<col style="width: 70%">
</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/try_decrypt"><span class="doc">TRY_DECRYPT</span></a></p></td>
<td><p>Error-handling version of DECRYPT.</p></td>
</tr>
<tr class="row-odd"><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-even"><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>
<tr class="row-odd"><td><p><a class="reference internal" href="functions/try_decrypt_raw"><span class="doc">TRY_DECRYPT_RAW</span></a></p></td>
<td><p>Error-handling version of DECRYPT_RAW.</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.
TRY_DECRYPT	Error-handling version of DECRYPT.
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.
TRY_DECRYPT_RAW	Error-handling version of DECRYPT_RAW.

Encryption Functions¶