> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/reference/error-codes/mariadb-error-codes-4000-to-4099/e4097.md).

# Error 4097: Compressed column can't be used in key specification

| Error Code | SQLSTATE | Error                                 | Description                                                    |
| ---------- | -------- | ------------------------------------- | -------------------------------------------------------------- |
| 4097       |          | ER\_COMPRESSED\_COLUMN\_USED\_AS\_KEY | Compressed column '%-.192s' can't be used in key specification |

## Possible Causes and Solutions

{% hint style="success" %}
This article doesn't currently contain any content. [You can help!](/docs/general-resources/about/readme/contributing-documentation.md)
{% endhint %}

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formId="4316" %}